IsNumber fails cast while IsBigInt passes cast

Question

Post reply

IsNumber fails cast while IsBigInt passes cast

Bill Talada

SSChampion

Points: 11954
More actions
May 5, 2010 at 4:16 pm

#234661

Comments posted to this topic are about the item IsNumber fails cast while IsBigInt passes cast

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

boris-1116387 SSCrazy Points: 2097 More actions · Answer 1

There is simpliest way to found non numeric symbols in string:

.....

if patindex('%[^0-9]%',@s)>0

set @value=0

....

Nadrek SSC-Insane Points: 20039 More actions · Answer 2

For character type strings you expect to be integers, there's also

ISNUMERIC(RTRIM(@value) + '.0e0')

Bill Talada SSChampion Points: 11954 More actions · Answer 3

I think everyone is totally missing the point that the IsNumeric function succeeds on junk that will fail when you later do a cast. Do your suggestions handle the strange cases in the comments at the top of my IsBigInt function?

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

akljfhnlaflkj

SSC Guru

Points: 76202

May 19, 2016 at 6:52 am

#1880185

Thanks for the interesting script.