This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / Help! Why the result of "select isnumeric('234d23')" is 1 but "select isnumeric('234de23')" is 0 in SQL Server? I need to identify the string is numeric char .
-xxu999(杰姆);
2005-12-23
(#2678326@0)
-
IsNumeric is not reliable to me. I would suggest to create your own function. If you try ...IsNumeric is not reliable to me. I would suggest to create your own function. If you try CAST('234d23' as float) or CAST('234e23' as float), you will know why IsNumeric returns 1. But, here is a good one, IsNumeric(char(9)) = 1, char(9) = Tab.
-leoxxll(leoxxll);
2005-12-23
{248}
(#2678740@0)
-
<a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13234" target="_blank" >URL</a>
-leoxxll(leoxxll);
2005-12-23
(#2678757@0)