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 errorwen 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
Moderator
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.
]]>