I have two tables from two different databases that I want to join together but I don't have a column on which this can be easily done by a join.
In table A I have a table with server names
In table B I have a table where one of the columns has a free text field (description).
I want to be able to create a search that searches for the server name within the description column and then add that description column onto the end of table A.
Table A Table B
description (join on searching for server name in description)
If you don't have a full text index on description, then you can use
SELECT A.name, A.server, A.customer, B.description FROM A JOIN B ON ' ' + B.description + ' ' LIKE '% ' + A.server ' %';
SELECT A.name, A.server, A.customer, B.description FROM A JOIN B ON CONTAINS(B.description, A.server)