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