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:
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