Find characters in text field

[emitrebel]

I need to find characters in a variable length text field. The field name is ITEM. The text in the field looks similar to this:

[ITEM]
12E
4444K
1202FP

I can't seem to get the starting position of the first (non-numeric) character.


Edd

 

[emitrebel]

Found it.

I found the answer I was looking for posted here:
http://www.access-programmers.co.uk/forums/showthread.php?t=61628