cancel
Showing results for 
Search instead for 
Did you mean: 

Possible problem with isnumeric function

Former Member
0 Kudos

If an integer is a number then why the following does not work:

declare @a char(1)

select @a="."

select convert(int, case when (isnumeric(@a) =1) then @a else "0" end)

While the follwoing works: 

declare @a char(1)

select @a="."

select convert(int, convert (numeric,case when (isnumeric(@a) =1) then @a else "0" end))

0

My question is: should isnumeric(".") return 1; as it does?

Accepted Solutions (1)

Accepted Solutions (1)

kevin_sherlock
Contributor
0 Kudos

see a related discussion at:

http://scn.sap.com/message/15213570#15213570

Answers (0)