All Forums Database
davidlarge22 1 post Joined 08/16
08 Aug 2016
Looking for keywords in a string of text in a variable from another table

hi all,
 
i have ran out of ideas for this one 
 
i have a table where there are 4 results that have keywords in them so 
 
Word 
a
b
c
d
and i have another table where these key words may be in that variable like 
A        B        C                D 
john Daivs london i went to shop in A 
 
im trying to write a query where i can say if the keyword from table A is in within the sentance of table 2/D then it is a result ?
 
any help would be great 

You must sign in to leave a comment.