Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trim Spaces in SQL
Message
De
25/01/1999 16:42:13
 
 
À
19/01/1999 19:48:52
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00177092
Message ID:
00180010
Vues:
43
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform