Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ron Moses More fun with ISNUMERIC() RE: More fun with ISNUMERIC()

  • July 5, 2010 at 10:34 pm

    #1188921

    Duncan Pryde (7/5/2010)

    Looks like a compatibility level issue. If you set the database to SQL Server 2000 compatibility mode, you lose the backslash character (92) from the list. Something to do with it being a valid currency character only in Japan/Korea for SQL 2000 but for all countries in SQL 2005-8.

    See about half way down this page

    Duncan

    Thank you, Duncan, you've right - my tempdb at compatibility_level=90 and the query from task returns 21, though my test database has compatibility_level=80