Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trim Spaces in SQL
Message
From
18/01/1999 05:21:14
Ernest Mezei
Monsey, New York, United States
 
 
To
18/01/1999 04:49:28
Alvin Goh
Singapore, Singapore
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Trim Spaces in SQL
Miscellaneous
Thread ID:
00177092
Message ID:
00177096
Views:
40
>Is there any function in SQL to trim spaces on a variable
>or field, like the LTRIM(), RTRIM() and ALLTRIM() in VFP?
>Pls advise, thanks.

You can use LTRIM and RTRIM in T-SQL
Ernest
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform