>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