No it doesn't. Here is an example on SQL 2005:
declare @test table ( testVal bit ) insert into @test (testval) values (0); insert into @test (testval) values ('Yes'); -- Results in error Conversion failed when converting the varchar value 'Yes' to data type bit. insert into @test (testval) values ('True'); -- Results in error Conversion failed when converting the varchar value 'True' to data type bit. insert into @test (testval) values ('No'); -- Results in error Conversion failed when converting the varchar value 'No' to data type bit. insert into @test (testval) values ('False'); -- Results in error Conversion failed when converting the varchar value 'False' to data type bit. select * from @test Sql expects data types that match. ColdFusion isn't strongly typed so false and no are equivalent to 0. Steve -----Original Message----- From: Nicki Tabb [mailto:vnt...@alaska.edu] Sent: Friday, February 18, 2011 1:17 PM To: cf-talk Subject: Re: Invalid Precision Value from SQL Server & CF9 SQL will read a NO or FALSE or 0 as the same ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm