>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