February 2009 - Posts

IsNumeric and Cast headache
13 February 09 06:04 AM | idragoev | 0 Comments   
An interesting issue was found by a colleague of mine: an exception when cast a nvarchar column to integer even if the column value was checked with IsNumeric on SQL 2000 SP4: select c.ID from dbo.COM_COMPANY c where IsNumeric(c.CODE) = 1 and convert Read More...