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.


3
1
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

Description

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
Hello,

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

Thank you for reporting this.

Cheers,
-Isaac