How Do Perform Lookup (1 Viewer)

[main-man]

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

 

[Pat Hartman]

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

Where Left(Postcode, 6) = RegionCode;