FROM
(
SELECT '01 Nulls' AS test, NULL AS c1, NULL AS c2 UNION
SELECT '02 Equal vals', 'Corbin', 'Corbin' UNION
SELECT '03 _ on left end of equal vals', 'Corbin_', 'Corbin' UNION
SELECT '04 _ on right end of equal vals', 'Corbin', 'Corbin_' UNION
SELECT '05 _ on both ends of equal vals', 'Corbin_', 'Corbin_' UNION
SELECT '06 _ replacing right 1 char', 'Corbin', 'Corbi_' UNION
SELECT '07 _ replacing left 1 char', 'Corbi_', 'Corbin' UNION
SELECT '07 _ replacing left 1 char', 'Corbi_', 'Corbin' UNION
SELECT '08 _ replacing right 2 chars', 'Corbin', 'Corb_' UNION
SELECT '09 _ replacing left 2 chars', 'Corb_', 'Corbin' UNION
SELECT '10 % on left end of equal vals', 'Corbin%', 'Corbin' UNION
SELECT '11 % on right end of equal vals', 'Corbin', 'Corbin%' UNION
SELECT '12 % on both ends of equal vals', 'Corbin%', 'Corbin%' UNION
SELECT '13 % replacing right 1 char', 'Corbin', 'Corbi%' UNION
SELECT '14 % replacing left 1 char', 'Corbi%', 'Corbin' UNION
SELECT '15 % replacing right 2 chars', 'Corbin', 'Corb%' UNION
SELECT '16 % replacing left 2 chars', 'Corb%', 'Corbin' UNION
SELECT '17 [] around 2 chars with 0 good', 'Corbin', 'Cor[ac]in' UNION
SELECT '18 [] around 3 chars with 1 good', 'Corbin', 'Cor[abc]in' UNION
SELECT '18.1 [] around char range with 1 good', 'Corbin', 'Cor[a-f]in' UNION
SELECT '18.2 [] around exclusionary char range with 1 good', 'Corbin', 'Cor[^a-f]in' UNION
SELECT '19 [] around 1 good char', 'Corbin', 'Cor[b]in' UNION
SELECT '20 [] around 1 bad char', 'Corbin', 'Cor[x]in' UNION
SELECT '21 [] around *', 'Corbin', 'Cor[_]in' UNION
SELECT '22 [] around %', 'Corbin', 'Cor[%]in' UNION
SELECT '23 escaped [] for % on left end', 'Cor%in', 'Cor[[%]in' UNION
SELECT '24 another combo test', 'Cor%in', 'Cor[%in' UNION
SELECT 'done.', NULL, NULL
) AS subquery
