Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.
Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).
How would you implement the above? I found 'has' operator but it doesn't match against compounded patterns as above. Thank you
I thought you could use TSQL in Azure Synapse - in which case I would implement it exactly as you have shown. Failing that, I believe there is a has_all operator
has_all
where myString has_all (Pattern1, Pattern2)