May 5, 2010 at 4:16 pm
Comments posted to this topic are about the item IsNumber fails cast while IsBigInt passes cast
June 2, 2010 at 10:17 am
There is simpliest way to found non numeric symbols in string:
June 11, 2010 at 8:12 am
For character type strings you expect to be integers, there's also
ISNUMERIC(RTRIM(@value) + '.0e0')
June 11, 2010 at 9:23 am
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?
May 19, 2016 at 6:52 am
Thanks for the interesting script.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply