I don't promise anything, but Mosha explains a bit about this in here:

http://www.mosha.com/msolap/articles/mdxconvertstringtonumber.htm

So maybe that's help?

(If it works don't break it. Publish this as a "new feature" in...

How well do you know your colleagues in a real disaster time? Well, in the army that's a very good question. who will do run forward and who will panic?...

I've got (3, 1) becuase my latest query returned 3 rows.

Heaps of thanks,

I have a cursor inside a trigger, and I always thought Cursor are from the word 'Curse'.

I had a stored proc written with the C word...

I use the following piece of code for a while now and with great success:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION ROUTINE_TYPE FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%text%' AND ROUTINE_TYPE = 'PROCEDURE'

http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html