Remove letter from end of field data 1

[netrusher]

I have a field in Access where there are six numbers and a U at the end of the six numbers. Is there a way I can run a query or something to get rid of the U at the end of each of the numbers?

 

[Remou]

You can update like so:

Left(fld,Len(fld)-1)

 

[netrusher]

Remou,

Thanks for your help.

Where do I put the code to update the table.

Also, I should have said that each data field has 6 numbers and then the U:

123456U

 

[Remou]

The line I posted will remove the last character of the field, regardless of length, so you may wish to test that the last character is a U. You can use the above in an Update query, being careful to back-up first:

[tt]UPDATE tblTable SET fld = Left(fld,Len(fld)-1)[/tt]

 

[netrusher]

Thanks Remou, I appreciate your help.