Search on part of a number (1 Viewer)

B

blueanchor

Registered User.

Local time

Today, 09:04

Joined

Aug 4, 2005

Messages

10

• Jan 16, 2006

• #1

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

 

R

Rickster57

Registered User.

Local time

Today, 02:04

Joined

Nov 7, 2005

Messages

431

• Jan 16, 2006

• #2

digits

Use the RIGHT, RIGHT$ function.

 

V

Vassago

Former Staff Turned AWF Retiree

Local time

Today, 05:04

Joined

Dec 26, 2002

Messages

4,751

• Jan 20, 2006

• #3

And try posting in the right section.