conversion error while converting varchar to bigint in sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

HI,

SQL

select ISNUMERIC('149972,')

out put:
1

select ISNUMERIC('149972=')

VB

out put:
0

here in first out put it show 1 and second out put it show 0

is it , is also include in int or not

Thanks
ramesh.m

Posted 18-Nov-12 22:39pm

ramesh4128

Updated 18-Nov-12 22:40pm

v2

Add a Solution

Comments

MT_ 19-Nov-12 5:33am

Does the explanation below answers your question?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MT_ · Answer 1 · 2012-11-18T22:53:00

According to definition on MSDN: "ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type. Valid numeric data types include the following:
int, numeric, bigint, money, smallint, smallmoney, tinyint, float, decimal, real"

Comma is allowed in Money, hence it is returning 1. It will also return 1 if you +, - £ etc signs in the input.

http://msdn.microsoft.com/en-us/library/ms186272.aspx[^]

Hope that helps. If it does, mark it as answer/upvote.
Thanks
Milind

André Kraak · Answer 2 · 2012-11-18T22:45:00

Solution 1

Quote: http://msdn.microsoft.com/en-us/library/ms186272.aspx[^]
ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0.

The '=' in the expression makes it a invalid numeric.

Posted 18-Nov-12 22:45pm

André Kraak

Comments

ramesh4128 19-Nov-12 4:53am

Please let me know the reason why this special character',' is only accepted as numeric. I tried with all special characters and returned as non-numeric except ','.

Thanks in advance.

MT_ 19-Nov-12 5:00am

Check details provided in my solution.

conversion error while converting varchar to bigint in sql server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

conversion error while converting varchar to bigint in sql server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us