CASE WHEN with multiple THEN ELSE
<p>Right now i get for <strong>reporting</strong> purposes the following data in <strong>3 different columns</strong>:</p>

<pre><code>//Number
                'CASE WHEN should_be.sh = "50"
                        THEN
                            REPLACE(SUBSTRING_INDEX(account.code,".",1)," ","")
                        ELSE
                            "500."
                    END',
// Account
                    'CASE WHEN should_be.sh = "50"
                            THEN
                            REPLACE(
                                SUBSTRING(SUBSTRING_INDEX(account.code,".",2),
                                    INSTR(account.code, ".") + 1)
                            ," ","")
                        ELSE
                            "92145000000"
                    END',
// Costsnumber
                        'CASE WHEN should_be.sh = "50"
                                THEN
                                    CASE WHEN LENGTH(account.code) &lt; 15
                                        THEN
                                            REPLACE(
                                                SUBSTRING_INDEX(account.code,".",-1)
                                            ," ","")
                                        ELSE
                                            ""
                                    END
                                ELSE
                                    ""
                            END',
</code></pre>

<p>If every condition meets <code>ELSE</code>, then the 3 columns look like that:</p>

<pre><code>+--------+-------------+------------+
| number |   account   | costnumber |
+--------+-------------+------------+
|    500 | 92145000000 |            |
+--------+-------------+------------+
</code></pre>

<p>How to combine the 3 columns, so I will have one column like that (for example in the ELSE case:</p>

<pre><code>+-------------------------+
|        combined         |
+-------------------------+
| 500-92145000000-(empty) |
+-------------------------+
</code></pre>