String Function

[Mackia]

This is probably a fairly simple query. I need to ascertain whether a text
field contains alpha chars at the beginning of the data i.e. if data is like
"A123456". I used isnumeric function but datatype is text so is there a
string function?

thanks
Tony

 

[JohnFol]

Not Isnumeric (Left(MyString, 1)) ??