>Jeff, can you give an example where 'a-f' are considered by ISNUMERIC to be convertable to a number?
Sure Frank,
There's others but these will do... only one out of a-f that I can't get to roll to 1 is "f". My mistake on that... ISNUMERIC is really fickle
These all return 1...
SELECT ISNUMERIC(0X0a)
SELECT ISNUMERIC(0X0b)
SELECT ISNUMERIC(0X0c)
SELECT ISNUMERIC(0X0d)
SELECT ISNUMERIC('0d01')
SELECT ISNUMERIC(0X0e)
SELECT ISNUMERIC(1e10)
This returns 0...
SELECT ISNUMERIC(0X0f)
--Jeff Moden
Change is inevitable... Change for the better is not.