look for certain data from another table

[hardtarget]

Hi,



i have 2 tables. Table A contains the full company name and Table B contains a shortened form of the company name.

e.g.

Table A
ABC Company Limited
Big Ball Company
Big Mac Ltd

Table B
ABC Company
Big Ball
Big Mac

What I want to do is run a query that looks for the data in Table B against Table A. Normally you could do an inner join query and find exact matches but I cant do this in this case. So the query would look for the words "ABC Company" in Table A

Thanks in advance.

[dcrake]

The big question is why do you have two set of company names in your database?

Which is the more accurate?
What happens if you have similar sounding names that when shortened are the same?

You should be using Primary keys anyway not textual descriptions.

David

[RuralGuy]

Look at the InStr() function.

[hardtarget]

dcrake, unfortunately its because users wont type the whole name when they fill out the form - only part of it.