Search on part of a number

[blueanchor]

I have a data base with the field named "PartNumber" this is a 13 diget number. How can I search on the last 7 digets only

 

[Rickster57]

digits

Use the RIGHT, RIGHT$ function.

 

[Vassago]

And try posting in the right section.