Home Forums SQL Server 2005 SQL Server 2005 General Discussion isnumeric issue RE: isnumeric issue
steveb.
SSC-Forever
Points: 46733
More actions
June 14, 2010 at 3:45 am
#1179728
becasue '2d3' = 2000 as a valid float value so ISNUMERIC will return 1
SELECT CAST('2d3' AS float)