Deleting surplus dashes and suffix's

  • Thread starter Susan from Florida
  • Start date
S

Susan from Florida

Field proj3 has many entries as follows:
03-25345-es
04-81856

On those entries in which a dash and initals appear, I
want to run an update query to remove them. I don't know
SQL and visual basic. The table is called project.

Sample language which I can copy and paste into the query
would be appreciated.
 
L

Les

Susan,
Do you always have the dash and initials in the same
place? If so, you should be able to get the results you
want with the following:

newfld:MID([yourfld],1,8)

This just takes your field, starts at position 1 and
selects 8 positions of data.

Hope this helps.
 
Top