Hi
I need to search the contents of a field for a job number and then display all of the records that contain that job number. My problem is that the data is an export from an accounts package and the field contains the job number plus the address and there is no logic to its input. For example:
12345, 1 The High Street London or High Street 12345
Is it possible to add a contains or like criteria to the search query?
Chris
