Browse by Tags

• exception
• IsNumeric

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...

Filed under: exception, cast, SQL 2005, IsNumeric