Thank you Mr Ernest for your prompt reply.
Do you mean that I can use LTRIM and RTRIM in writing the table
Triggers? I have searched in the SQL Help, there isn't any of
such command/function available to code the syntax.
Pls enlighten me, thanks.

>>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