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,