>
>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).
You're welcome.
>I'm not sure what T-SQL is, I'll have to check that out. But ltrim and rtrim work great for me.
It's, simply put, SQL Server programming language but it's more than that. The LTRIM() and RTRIM() functions are part of it. It's covered in greate detals in BOL (SQL Server books online) which are installed as a part of SQL Server client tools or can be downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en. It's indispensable resource for SQL Server programmer/DBA.
--sb--