3TgSpc6Q

1DROP TABLE IF EXISTS #ColumnSet
2GO
3
4CREATE TABLE #ColumnSet
5(
6    Id        INT          IDENTITY (1, 1) NOT NULL
7  , Value1    VARCHAR(100) SPARSE NULL 
8  , Value2    VARCHAR(100) SPARSE NULL 
9  , Value3    VARCHAR(100) SPARSE NULL 
10  , Value4    VARCHAR(100) SPARSE NULL 
11  , AllValues XML COLUMN_SET FOR ALL_SPARSE_COLUMNS
12)
13GO
14
15INSERT INTO #ColumnSet
16(Value1, Value2, Value3, Value4)
17
18VALUES
19('POSITIVE', NULL, NULL, NULL),
20('NEGATIVE', NULL, 'NEGATIVE', NULL),
21(NULL, NULL, 'NEGATIVE', 'POSITIVE'),
22('NEGATIVE', NULL, NULL, NULL)
23GO
24	
25SELECT
26    *
27
28FROM
29    #ColumnSet
30
31WHERE
32    AllValues.value('/', 'nvarchar(4000)') LIKE '%POSITIVE%'