Transport, Media, SportHe was looking for the keyword "Sport" and was matching all of the above 4 rows, rather than just rows 1, 3 and 4.It took me a bit of head scratching, but I finally proposed the following solution:
WHERE ' ' + REPLACE(Keyword,',',' ') + ' ' LIKE '% Sport %'
So, prefixing and suffixing the data with a space, and replacing the comma being used for separation with a space, and then comparing it against our target word which is also prefixed and suffixed by a space. This solution feels like a bit of a cludge, but less arduous than implementing a Split function. Opinions always welcomed