Self Note / SQL Server

SQL Query for Multi-Values In An Encoded String

Consider a table with an textual column that encodes multi-values like so:

How can we query for all rows using an OR criteria? For a single value, it’s quite easy by searching for the string (in this case, an...