How Do Perform Lookup

main-man

Registered User.
Local time
Today, 21:29
Joined
Oct 20, 2005
Messages
48
Hi i really need help!

i need to be able to use "lookup", i have a set of postcodes from 3000 customers, i need to extract these and compare them to lists i have of postcodes, which make up a region. And run queries from these

e.g a customer on my database has the postcode BD21 7KK

On my list of postcodes i have on paper - WEST YORKSHIRE - BD21 7

therefore The BD21 7KK Customer falls in the West Yorkshire region.

I need to do this four 4 regions with lists i have on paper then run queries.

Can some one please provide the neccessary steps?

Or even give me an example made?

Im really stuck on this at the moment and me job depends on it ! :(

Thanks
 
If you want to match on the first 6 characters, use the left() function to extract them:

Where Left(Postcode, 6) = RegionCode;
 

Users who are viewing this thread

Back
Top Bottom