using-executesql-to-find-like

ExecuteSQL ( "SELECT "cc.email" FROM cc WHERE "cc.CustomerNumberKey" = 1000 AND "cc.Subscriptions" LIKE '%Critical Needs%' " ; "" ; "" )

Use "Like" then the value you wish to find with "%" on the at the beginning and end. This will look for that phrase anywhere in the field.