*repeats the group contents below any number of times:
,the literal , (4410 / 548 / 2C16)
\s*any whitespace character, repeated any number of times
CASEthe literal text CASE (case insensitive) \s+any whitespace character, repeated at least once
Non-Capturing Group(?:(?:WHEN\s+.+THEN\s+.+)(?:\s+WHEN\s+.+\s+THEN\s+.+)*) Non-Capturing Group(?:WHEN\s+.+THEN\s+.+) WHENthe literal text WHEN (case insensitive) \s+any whitespace character, repeated at least once
.+any character (except for line terminators), repeated at least once
THENthe literal text THEN (case insensitive) \s+any whitespace character, repeated at least once
.+any character (except for line terminators), repeated at least once
Non-Capturing Group(?:\s+WHEN\s+.+\s+THEN\s+.+)* *repeats the group contents below any number of times:
\s+any whitespace character, repeated at least once
WHENthe literal text WHEN (case insensitive) \s+any whitespace character, repeated at least once
.+any character (except for line terminators), repeated at least once
\s+any whitespace character, repeated at least once
THENthe literal text THEN (case insensitive) \s+any whitespace character, repeated at least once
.+any character (except for line terminators), repeated at least once
\s+any whitespace character, repeated at least once
ELSEthe literal text ELSE (case insensitive) \s+any whitespace character, repeated at least once
.+any character (except for line terminators), repeated at least once
\s+any whitespace character, repeated at least once
ENDthe literal text END (case insensitive)