Delete left two characters

  • Thread starter Thread starter Dan C.
  • Start date Start date
D

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
 
Try ...

Mid([MyField], 3)

This will return the entire contents of your field beginning with the 3rd
character.
 
If you actually want to delete the two character then use
Cheryls example in an update query.

Jim
 
Back
Top