Explicit conversion | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Explicit conversion

in sql 2000 i could do this: SELECT * FROM MyTable WHERE Fld1 > 8 AND Fld2 = ‘test’ (where Fld1 is a varchar) and it returns no error
wen i ran the same query on SQL2005 five it gives me an error, because there are some values in Fld2 which are not numbers. Is this somewhat a new rule in sql2005. if yes, could someone give me a link where it explains such. thanks!
Please move to Yukon Forum.
Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.