IsNumber fails cast while IsBigInt passes cast

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by William Talada » IsNumber fails cast while IsBigInt passes...

IsNumber fails cast while IsBigInt passes cast

Rate Topic

Display Mode

Topic Options

Author

Message

Bill Talada

Posted Wednesday, May 05, 2010 4:16 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:31 AM
Points: 65, Visits: 443

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

Post #916557

boris-1116387

Posted Wednesday, June 02, 2010 10:17 AM

SSChasing Mays

Group: General Forum Members
Last Login: Thursday, May 09, 2013 1:37 PM
Points: 649, Visits: 60

There is simpliest way to found non numeric symbols in string:
.....
if patindex('%[^0-9]%',@s)>0
set @value=0
....

Post #931488

Nadrek

Posted Friday, June 11, 2010 8:12 AM

Say Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 12:28 PM
Points: 675, Visits: 2,031

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

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

Post #936053

Bill Talada

Posted Friday, June 11, 2010 9:23 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:31 AM
Points: 65, Visits: 443

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?

Post #936123

« Prev Topic | Next Topic »

Permissions