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
Didn't find any FAQs or postings addressing this.
Thanks!
- Geno