>lcmyString = "123456789 Boldorn"
>
>I want to return position 11 because it is the first non numeric position (B). just can't think of it today...
lcmyString = "123456789 Boldorn"
? AT(LEFT(CHRTRAN(lcmyString, "123456789",[]),1),lcmyString)
lcmyString = "Boldor2121212n"
? AT(LEFT(CHRTRAN(lcmyString, "123456789",[]),1),lcmyString)
lcmyString = " Boldorn 123456789"
? AT(LEFT(CHRTRAN(lcmyString, "123456789",[]),1),lcmyString)
The first returns 10 becasue space is non-numeric :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
