More fun with ISNUMERIC()

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 Ron Moses » More fun with ISNUMERIC()

32 posts, Page 4 of 4

«««1 2 3 4

More fun with ISNUMERIC()

Rate Topic

Display Mode

Topic Options

Author

Message

jawad.zubairi

Posted Thursday, July 15, 2010 12:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, July 15, 2010 12:23 PM
Points: 5, Visits: 7

It does as the MSDN says,

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uas9/html/5193c976-9dcd-459c-abba-8c3c44e7a7f2.htm

ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($). For a complete list of currency symbols.

Post #953401

L' Eomot Inversé

Posted Saturday, September 18, 2010 1:10 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:35 AM
Points: 7,078, Visits: 7,119

Nice question. I particularly liked the inclusion of the string in the final select, so that people could see what was going on.

Surprised by some of the comments - I though everyone would know the what the character codes in the 9 to 13 range represent, I guess some of teh youngsters never needed to know that stuff because (a) modern text handling tools are a bit higher level that some of the old ones and (b) people stopped reading punched tape maybe 30 years ago.

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #988769

« Prev Topic | Next Topic »

32 posts, Page 4 of 4

«««1 2 3 4

Permissions