I am using SQL Server Express 2005.
I need to do a string compare in my query and it is something similar to:
ItemTexts.BookTitle LIKE '%Dictionary%'
In the above case I am checking for the existance of the string literal within the ItemTexts.BookTitle field.
However, instead of a string literal, the string to check is contained in another table field. But I obviously cannot do:
ItemTexts.BookTitle LIKE '%ItemCategories.LookupString%'
Can you explain how I can achieve the above bearing in mind it is between table fields?