Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trim Spaces in SQL
Message
From
25/01/1999 16:42:13
 
 
To
19/01/1999 19:48:52
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00177092
Message ID:
00180010
Views:
44
>Hello Michael,
>I tried to find the LTRIM and RTRIM function in 6.5 BOL but
>couldn't locate the syntax. Any advise?
>

I thought it was listed with the other functions. I just looked it up since I've got a 6.5 BOL handy. Try searching on String Functions in the BOL. It basically works like you would think:

SELECT LTRIM(expression)
SELECT RTRIM(expression)

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform