Help with update query 2

[JCAA]

How would I make an update to the following:

I have a file and some of the part numbers have an –P in the end so instead of for example 1234 it is1234-P. what would my criteria in an update query be to delete all “-P’s”
Thanks!

 

[mgolla]

In the Where statement:

WHERE (Right([PartNumber],2)="-P&quot

is what you would use to delete only partnumbers with a -P in the number

 

[lespaul]

UPDATE TABLENAME SET FIELDNAME = Left([PartNumber], 4) WHERE (Right([PartNumber],2)="-P&quot

Will change the field value from 1234-P to 1234


Leslie