Trim first two characters in a field

  • Thread starter Carlton A. Barlow
  • Start date
C

Carlton A. Barlow

I need to trim the two charactesr from a field. I you have a simple sql
command that would be great too.
 
S

Sprinks

Hi, Carlton.

In an Update query, change the value of [YourField] to:

=Right([YourField],len([YourField])-2)

Sprinks
 
S

Sprinks

Fred,

You're right; Mid is a more efficient call. But shouldn't it be
Mid([OldField],3) to trim the first two?

Sprinks


fredg said:
I need to trim the two charactesr from a field. I you have a simple sql
command that would be great too.
Click to expand...

NewField = Mid([OldField],2)
Click to expand...
 
Top