[dba-SQLServer]Trim function

Thanks Doris, I'll give it a try.

 

Mark

 

-----Original Message-----
From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
Sent: Wednesday, May 21, 2003 10:05 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Trim function

 

RTrim(LTrim(" xxx "))

 

Doris Manning

Database Administrator

Hargrove Inc.

www.hargroveinc.com <http://www.hargroveinc.com/> 

	-----Original Message-----
	From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark
Boyd
	Sent: Wednesday, May 21, 2003 8:40 AM
	To: SQLServerList
	Subject: [dba-SQLServer]Trim function

	Is there a way to trim a field in one step?

	I use the 'ltrim' function, but then need to use 'rtrim'.  I
would like to trim fields in one step, not two.

	 

	Thanks,

	Mark Boyd

	Sr. Systems Analyst

	McBee Associates, Inc.

	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030521/4b818efe/attachment.html>