http://blogs.msdn.com/b/psssql/archive/2008/08/25/isnumeric-returns-1-true-and-i-expected-0-false.aspxThe string '100,200,300' has fooled many a customer and support engineer alike. select cast('100,200,300' as bigint) Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to bigint. One might argue that this is a bigint value.&#160; Howeveren-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/psssql/archive/2008/08/25/isnumeric-returns-1-true-and-i-expected-0-false.aspx#8896990Tue, 26 Aug 2008 13:52:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:8896990colin leversuch-roberts<p>This is also true when just a decimal point ( full stop ) is set for conversion.</p> <p>select isnumeric('.') &nbsp;will return true</p> <p>select convert (int,'.') &nbsp;will fail</p> <p>Seen this cause a few &quot;bugs&quot; in my time.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=8896990" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2008/08/25/isnumeric-returns-1-true-and-i-expected-0-false.aspx#8894177Mon, 25 Aug 2008 19:04:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:8894177car insurance &raquo; IsNumeric Returns (1/TRUE) and I Expected (0/FALSE)<p>PingBack from <a rel="nofollow" target="_new" href="http://hoursfunnywallpaper.cn/?p=2932">http://hoursfunnywallpaper.cn/?p=2932</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=8894177" width="1" height="1">