Home Dashboard Directory Help
Search

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


Status: 

Closed
 as By Design Help for as By Design


3
1
Sign in
to vote
Type: Bug
ID: 273456
Opened: 4/25/2007 2:34:00 PM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

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.

Details
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
Sign in to post a workaround.
Posted by Adam Machanic on 4/25/2007 at 5:09 PM
See:

http://classicasp.aspfaq.com/general/what-is-wrong-with-isnumeric.html