Thanks!  I can use this query in my screen form to determine if a specific table is indexed for full text search before I submit a query that has the...

I tried doing the select you recommended but I got the following error message back in Query Analyzer:

    SELECT permission denied on object 'syscursorcolumns', database 'master', owner 'dbo'.

Do I have...

Sorry, I misspoke there.  I tried Numeric(10,4), not Numeric(6,4). 

Jim

Thanks, Remi!  That worked.  Earlier I tried using the CAST() function but instead of Decimal I specified Numeric which for some reason didn't work.  When the cursor got to my...

It is a numeric column, but it is not a column that exists in the table that I'm selecting from.  It's a column that I am creating dynamically at the...

Is there no other way?  Doesn't MS-SQL have a way of using the value of a variable to substitute in places like the ORDER BY clause?  I believe I've seen T-SQL...