Search for match

[3dman]

Hi all,

I have two sets of columns in MS Access 2003.

Column 1: contains suburb + state code, e.g. Altona VIC

Column 2: Cotains suburb name, e.g. Altona

Would like to find a match for each suburb name, but the state code in column 1 is a problem.

I've tried using "Not Like" and the trim function but those aren't practical, is there a better way to do this?

Thank You,

Dave

 

[jjturner]

Is this what you're looking for? -

Criteria for Column 1:
Like [Column 2] & "*"

 

[3dman]

Hi jjturner,

Thank You X 1000

Cheers,

Dave

 

[jjturner]

You're welcome Dave