>DECLARE @colname VARCHAR(100) = 'cid' >DECLARE @tblname VARCHAR(100) = 'caccount_credits' >DECLARE @str VARCHAR(max) = '' > >SELECT @str = @str + 'SELECT CASE WHEN NOT (' + @colname + ' LIKE expression + ' -- and here is where I don't know what to put in so '%' renders correctly in the result > >???? > >SELECT CASE > WHEN NOT (Cid LIKE expression + '%' OR Cid LIKE '{' + expression + '}%') THEN Cid > END >FROM @test T > CROSS APPLY (SELECT REPLACE('00000000-0000-0000-0000-000000000000', '0', '[0-9a-fA-F]') COLLATE Latin1_General_BIN) C2(expression) >WHERE NOT (Cid LIKE expression + '%' OR Cid LIKE '{' + expression + '}%') > >>
>>DECLARE @Test TABLE (Cid char(36)) >> >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >>INSERT INTO @test VALUES ('adfasdfadfasdfasdfasdfas') >>INSERT INTO @test VALUES ('63F4B1CD-80DD-4F96-B5EF-520A4FDADA63') >> >>SELECT CASE >> WHEN NOT (Cid LIKE expression + '%' OR Cid LIKE '{' + expression + '}%') THEN Cid >> END >>FROM @test T >> CROSS APPLY (SELECT REPLACE('00000000-0000-0000-0000-000000000000', '0', '[0-9a-fA-F]') COLLATE Latin1_General_BIN) C2(expression) >>WHERE NOT (Cid LIKE expression + '%' OR Cid LIKE '{' + expression + '}%') >>