[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/d0ba1fff/attachment.html>