Hi guys,

I am wondering how i address this problem i am trying to search a table of uk postcodes the problem is simply the table contains part postcodes and i am trying to search with full postcode I.e

Table contents:

IG1
IG10
N1
SE1
SE10
SE16EJ
SE16FJ

but the postcode being typed in is complete

Typed by user:

IG1 3GH
IG10 3PG
N1 2NN
SE1 2BN
SE103JC

These are just examples I am awear of the LIKE sql but this works in reverse to what i am trying to achieve........ I think.

Any direction would be great.