TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them..
http://beyondrelational.com/puzzles/challenges/38/search-for-two-keywords-within-the-maximum-distance-of-one-word-between-them.aspx