Mike and Doris Manning
mikedorism at ntelos.net
Wed May 21 09:05:02 CDT 2003
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/82885516/attachment.html>