Chapter 4 Exercise 77

7. Create a regular expression pattern that retrieves all Merchandise items that refer to dry food which might be written as in either order (dry...food or food...dry).

select *
from merchandise
where dbo.RegexMatch(Description,N'(Food.*Dry)|(Dry.*Food)')
<> 0