sql: Check if 1 or more items of one delimited string exist in another

[chebil]

Hi all,
Which is the best way to check if an item or more of one delimited string exist in another?
I'd like to pass 2 delimited strings to a UDF and get back TRUE if at least one item of
the first delimited string exists in the second delimited string.

delStr1="US,FR,DE"
delStr2="GB,DE,CA,PL"
delStr3="CN,DK,IT"

UDF_CheckDelimitedStringItems(delStr1,DelStr2)= TRUE
UDF_CheckDelimitedStringItems(delStr2,DelStr3)= FALSE

 

[markros]

The best way will be to split both strings and check this way:

select * from dbo.fnSplit(@String1, ',') where Value in (select Value from dbo.fnSplit(@String2,',')

Take a look at this blog post
Parsing multiple ranges to SP which gives you several links to the string splitting related blogs.

PluralSight Learning Library