- Stack Exchange Data Explorer

WITH rawdata(color) As ( SELECT 'Blue' UNION ALL SELECT '...

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for programmers

-- Enter Query Title
-- Enter Query Description
WITH rawdata(color) As
(
SELECT 'Blue' UNION ALL SELECT 'Red'
), rules(color_condition,rules_id) AS
(
SELECT 'B%',1
)
SELECT color FROM rawdata 
WHERE color LIKE (SELECT TOP 1 color_condition 
                  FROM rules WHERE rules_id=1)

created mar 9 11