What can be read out of GDPR right now, an organization can not just disclose a new purpose. Changing the purpose means you've got to get the explicit consent from...

We'll need to help our organization extract more value from the data we are allowed to hold, meaning those of us that are data professionals will become more important....

I now tried to build a long string without ranges, and that seemed to work.

DECLARE @findstr NVARCHAR(50)

SET @findstr = '%['+CHAR(1)+CHAR(2)+CHAR(3)+CHAR(4)+CHAR(5)+CHAR(6)+CHAR(7)+CHAR(8)+CHAR(11)+CHAR(12)+CHAR(14)+CHAR(15)+CHAR(16)+CHAR(17)+CHAR(18)+CHAR(19)+CHAR(20)+CHAR(21)+CHAR(22)+CHAR(23)+CHAR(24)+CHAR(25)+CHAR(26)+CHAR(27)+CHAR(28)+CHAR(29)+CHAR(30)+CHAR(31)+']%'

SELECT COUNT(*) FROM myTable WHERE patindex(@findstr, col1) > 0

-- Result:...