Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ISNUMERIC returns 1 for valid hex?

Status
Not open for further replies.

genomon

Programmer
Joined
Aug 20, 2001
Messages
2,449
Location
US
Recently found that the ISNUMERIC function returned a 1 (true) when checking a varchar field containing "4D69". I assume this is because this is a valid hexadecimal number; I ended up writing a user-defined function to check for values in each byte between 0 and 9 that works OK. Anyone know if this is by design, or a bug? Seems to me if I can't CAST or CONVERT to hex that it ought to return 0 (false).
Didn't find any FAQs or postings addressing this.
Thanks!
- Geno
 
Scientific notation? (should work for D and E but not for the rest of alphabet, assuming that number isn't out of domain range).


-----
Math problems? Call 0800-[(10x)(13i)^2]-[sin(xy)/2.362x]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top