Update Query 101

[Homer J]

I'm very new to Update query & need some help.

I have a table with policy numbers (polno) which are in the format of
"ABC 123456789"
How do I create an update query to remove the ABC at the front of the policy number

I tried this but it didnt work
UPDATE [Renewal MI] SET [Renewal MI].polno = "polno"
WHERE ((([Renewal MI].polno)=Right([polno],9)));

am I close???

 

[Jigs]

OR,

You can even try for

If number of charecters present in the field name POLNO are same then u can try

UPDATE [Renewal MI]
SET polno = RIGHT(polno , LEN(polno )-4)

Jigs