SQL Server. Compatibility level 120.
I have a table in which a VARCHAR column contains semicolon-separated integral values. I want to SELECT against the values in this column as if they existed somewhere in a column of ints.
Because of compatibility, I can not use STRING_SPLIT. I also can not create globally available functions.
If necessary, however, I can create a temporary table. How do I proceed? A kind of nesting of WHILE loops (one for the rows of the table, another for the semicolons in the string)?