IsNumeric

[vitordf]

Hi,

Wonder if someone could help me, I have a formula in excel which determines where the first "number" is located in the string:



{=IFERROR(MATCH(TRUE,ISNUMBER(1*MID($C2,ROW($1:$90 00),1)),0),1)}

Example:
5hn05 - the result would be 1
h5n05 - the result would be 2

I need to do the same but as a SQL query, and for some reason I can't figure out how, so any help is very much appreciated.

Kind regards,

[JoeM]

Also asked and answered here: http://www.mrexcel.com/forum/microso...isnumeric.html