Thank you Sergey,

For both of your responses to my questions...when I trapped aerror() I noticed the user didn't have rights to execute my new stored procedure (for my earlier post).

I'm not sure what T-SQL is, I'll have to check that out. But ltrim and rtrim work great for me.

Thanks again,
Paul

>>I'm new to writing sql code in Store Procedures. Not as much functionality as VFP is there? :)
>
>It depends on what you're doing. The T-SQL is more powerfull in the area of set oriented processing.
>
>>Can I trim a string variable prior to inserting a new record?
>
>See LTRIM() and RTRIM() in BOL.