Comparing data within a field

I have a field called ID. I want to remove any duplicate ID's based on the last 5 digits. So If I have 3 ID A00001 and 000001 and 000002, I would like to just show 000002 after I the query is run.

Thanks,

[215 byte] By [MichaelF] at [2007-12-17]