Given a SQL CASE expression with nested CASE expressions, I'm looking for the best way to emulate a C break or Python pass within a nested CASE expression so I can evaluate the rest of the outer WHEN choices.

For example, imagine

```
select CASE 
         WHEN C1 THEN CASE
                      WHEN CA THEN 100
                      WHEN CB THEN 200
                     -- implied ELSE NULL
                     END
         WHEN C2 THEN CASE
                      WHEN CC THEN 300
                      WHEN CD THEN 400
                      ELSE 500
                     END
         WHEN C3 THEN CASE
                      WHEN CE THEN 600
                     END
         WHEN C4
... etc

```

assume that conditions C1 and C3 are both true, C2 and C4 are false.
also assume that CA and CB are false, CE is true.

The inner case for C1, takes the implied ELSE NULL. I'd like to functionally be able to say ELSE BREAK and allow C2, C3, etc to be evaluated as part of the outer case. The desired result is 600.

The best way I've found is to replace the outer case with a COALESCE of all the inner cases.

such as 

```
COALESCE(
           CASE C1 THEN
           CASE
                WHEN CA THEN 100
                WHEN CB THEN 200
           END
           END
           ,
           CASE C2 THEN
           CASE
                WHEN CC THEN 300
                WHEN CD THEN 400
                ELSE 500
           END
           END
           ,
           CASE C3 THEN
           CASE
                WHEN CE THEN 600
           END
           END
          ,
... etc   )

```

Anyone have other ideas? With several levels of CASE, the source code blows up in size which makes it harder to maintain.

I'm using standard SQL 2008, no extensions as one might find in T/SQL or SQL/PLUS etc.

Maybe you have a way to format my solution to make it most readable?

thanks.