Using Like comparison over multiple patterns
I would like to be able to match a single field based upon multiple patterns contained in another table, kind of like and IN clause for LIKE comparisons.  The following query obviously doesn't work, but it expresses what I am trying to accomplish.

    SELECT * 
    FROM TableA 
    WHERE TableA.RegCode Like (
    	SELECT '%' + TableB.PartialRegCode + '%'
    	FROM TableB)

I'd rather not resort to cursors if there is a better way.

Using Like comparison over multiple patterns
===

I would like to be able to match a single field based upon multiple patterns contained in another table, kind of like and IN clause for LIKE comparisons.  The following query obviously doesn't work, but it expresses what I am trying to accomplish.

    SELECT * 
    FROM TableA 
    WHERE TableA.RegCode Like (
    	SELECT '%' + TableB.PartialRegCode + '%'
    	FROM TableB)

I'd rather not resort to cursors if there is a better way.
