[AccessD] Remove last Letter

Hi,

I have a column in my Fixed Assets List.  The column
has The Asset Number.  Many of the asset numbers end
with 8.  Now I am requested to remove the 8 if it is
the last digit.

How can I do that using an update query.

Thanks
Paulin

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com