can you link 2 database using 'Like'

[Guest]

trying to categorize part description based on keywords or nouns in a 2nd
table using Like.... is this possible????

Noun table has 3000 records

Part desc table has 100,000 records - desc field is text - 256 chars

Is there a way to link them???

Thks

Bruce

 

[Ken Snell \(MVP\)]

A non-equi-join query might be what you want, but it will be nonupdatable.
Suppose you want to join using the full contents of a field in one table
with the first four characters of a field in a second table:

SELECT Table1.*, Table2.*
FROM Table1 LEFT JOIN Table2
ON Table1.FieldName Like (Left(Table2.FieldName1, 4));