Data 'contains' rather than exact match
Hi
I am working on some data searches in the UK and want to search by a number of items including postcode. I have used DataAssist to produce the pages and it all works OK. However, what I want is for the search on the postcodes to search for records containing part of the postcode (eg TW12) rather than being an exact match of the whole postcode. I have a table with the part postcodes in but how can I get this to work?
Many thanks