Delete left two characters

[Dan C.]

I'm trying to delete with code the left two characters in
a text string. I can do it with "find and replace", but
I want to do it with code.

For example, I would like to delete the 02 at the
beginning of these text strings:
0210102009B
0210102008

An example of a trim function in an update query will
work also.

Thanks

 

[Cheryl Fischer]

Try ...

Mid([MyField], 3)

This will return the entire contents of your field beginning with the 3rd
character.

 

[GreySky]

Something like:

strData = right(strData, len(strData) - 2)

?

David

 

[Jim/Chris]

If you actually want to delete the two character then use
Cheryls example in an update query.

Jim