SQL Server 2000 IsNumeric() function returns True for '-', '+', '$' values. - by E7617DA5-9B20-4F23-9B93-86871D284737

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 273456 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 4/25/2007 2:34:00 PM
Access Restriction Public


While trying to convert a varchar field to a numeric in transact sql, I found the isNumeric() function returns a true value for a minus, plus, and dolloar sign value.  Even though the isNumeric() functions thinks these are numbers,  the Convert() function doesn't agree and throws the following error: Server: Msg 8115, Level 16, State 6, Line 10
Arithmetic overflow error converting varchar to data type numeric.

Sign in to post a comment.
Posted by Microsoft on 5/27/2007 at 3:18 PM

This behavior is by design and is documented in Books Online. We are considering IsXXX enhancements for future releases.

Thank you for reporting this.