Take a look at this.

A simple JOIN or EXISTS can do the trick.

/* Return ALL records from @productList that are LIKE products in @softwareReferenceList */

select p.*

from @productList p

JOIN @softwareReferenceList s ON p.Product LIKE s.Product

/*where Product like in(select Product from @softwareReferenceList)*/

order by 2

select p.*

from @productList p

WHERE EXISTS( SELECT 1 FROM @softwareReferenceList s WHERE p.Product LIKE s.Product)

/*where Product like in(select Product from @softwareReferenceList)*/

order by 2