I hope someone else can explain why a backslash at the start of the string is considered numeric, as I was surprised at that myself.
I've managed to find this info:
http://msdn.microsoft.com/en-us/library/bb510680(v=sql.100).aspx
The backslash character (\) is accepted in all string to money conversions in all languages. ISNUMERIC would return true when \ is used as a currency symbol.
http://blogs.msdn.com/b/michkap/archive/2005/10/12/479561.aspx
_______________________________________________
www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)