Thanks for the article, it explains the APPLY in a simple and straightforward manner.

As a newby, could you explain to me why and when you would use :

SELECT * FROM dbo.SearchString as S

CROSS APPLY

(SELECT ProductName, Price

FROM dbo.Product

WHERE ProductName like '%' + S.String + '%') as X

instead of

SELECT * FROM dbo.SearchString as S

inner join

(SELECT ProductName, Price

FROM dbo.Product ) as X

on ProductName like '%' + S.String + '%'

Thanks