Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-10-02 : 19:08:26
|
Bug..ISNUMERIC(', ') RESOLVES TO 1CAST(', ' AS INT)Syntax error converting the varchar value ', ' to a column of data type int.Sam |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-02 : 19:43:36
|
| I think the best way to interpret how IsNumeric works, is that anything that is ABSOLUTELY NOT numeric in any way, shape, or form, will return a zero. Since a comma could appear in a number, and no other non-numeric character appears in that string, it will return a one instead.You should back up an IsNumeric test with a NOT LIKE '%[^0-9.-]%' comparison as well, if you need to be sure something contains only valid numeric symbols. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-10-02 : 20:26:36
|
| Thanks Rob.Works fine now.Sam |
|
|
|
|
|
|
Bummer