wware (9/27/2010)
Experimenting with the code in this question, I am getting different results from two SQL 2008 servers. One evaluates '\' as numeric. The other doesn't. They both have collation SQL_Latin1_General_CP1_CI_AS. Can anyone point me in the right direction on how to research what setting might be different between the two servers? Thanks.
The first things to look at would be the patch level (SELECT @@VERSION) and the compatibility level (SELECT name, compatibility_level FROM sys.database)