ColdFusion 9 running on MS-SQL 2008 breaks query

This simple query works fine on MS 2005 database but fails on an MS 2008 server: 1. First test: select suite from house_final_drawings where suite in (100,200) Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the nvarchar value 'dddd' to data type int. 2. Second Test: If single quotes are put around the 'IN' list items the query works on SQL 2008. select suite from house_final_drawings where suite in ('100','200') Any ideas why this behavior change in SQL 2008? The querys both work when run directly in SQL Studio.

You may want to check the data type, when whomever updated the database may have defaulted the suite column to varchar or other text. ----- Excess quoted text cut - see Original Post for more -----