query to find 2 words with anything "blank" inside

oscar_otrebla · June 30th, 2009, 11:25 AM

Hi guys,

My question is about how to make a query to find two words with blanks in between. I mean: If I want to find: 'Hello world' but it doesn't matter if it's 'Hello world' or n blank spaces in between, or even tabs or intros (CHAR(13)) in an nvarchar(max) field. I know I can try something like this:

Code:

SELECT ItemID, Description FROM Items WHERE Description LIKE 'Hello[ ' + CHAR(9) + CHAR(13)']world'

However, this means that the two words (hello and world) may have one occurence of a blank, tab or intro symbol in between. The point here is that it should find this two words separated by "n" blanks, tabs or intros (or any combination of them; I mean, there may be a blank and a tab separating both words, and still it should match).

Any help would be greatly appreciated.

Thanks in advance