Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I trim a parameter of a stored procedure in SQL?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01097892
Message ID:
01097987
Views:
15
>
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform