I'm using Access 2003 and here's my problem:
I have a text field that contains a string of characters that I need to strip out. The string of characters could be anywhere in the text and may or may not be separated by spaces.
I also have a table that contains all of the strings that I'm looking for. I'm trying to search the text field in table A for any of the strings contained in table B.
For example, this will work if I know what I'm searching for: Instr(1,tableA.colum, 'BD8695H')
The problem is that I don't know what I'm searching for. I tried a sub-query in the Instr function but that is not allowed and would not be efficient:
Instr(1,tableA.colum, (select column1 from tableB))
Can someone point me in the right direction as to how I should be handling this?
I have a text field that contains a string of characters that I need to strip out. The string of characters could be anywhere in the text and may or may not be separated by spaces.
I also have a table that contains all of the strings that I'm looking for. I'm trying to search the text field in table A for any of the strings contained in table B.
For example, this will work if I know what I'm searching for: Instr(1,tableA.colum, 'BD8695H')
The problem is that I don't know what I'm searching for. I tried a sub-query in the Instr function but that is not allowed and would not be efficient:
Instr(1,tableA.colum, (select column1 from tableB))
Can someone point me in the right direction as to how I should be handling this?