Update query is not updating a value in the first 3 positions of text field

[Pack10]

I have a large table that is fed from Sharepoint. One of the fields has some junk in it.
One field that i need to clean up is a 10 character field....some contain "INC-and then the numeric values....
Trying to do an update query to remove the INC INC- or INC - .....
I still see them in the table.

This is the code that access creates....
UPDATE [Combined Quality Tracker] SET [Combined Quality Tracker].[INC ID] = Right("0000000000" & [INC ID],10)
WHERE (((Left$([INC ID],3))="INC")) OR (((Left$([INC ID],4))="INC-")) OR (((Left$([INC ID],5))="INC -"));

 

[Pack10]

Solved it using 3 different queries....