Question: I'd like to add some metadata to the header of my action mailer preview pages.
I thought the easiest way would be to override this file somewhere in my project:
<https://github.com/rails/rails/blob/4-2-stable/railties/lib/rails/templates/rails/mailers/email.html.erb>

Seeing as other things can be overridden in the lib/templates folder I thought something similar could work. I've tried the following without luck:

* lib\templates\rails\mailers\email.html.erb
* lib\templates\mailers\email.html.erb
* lib\rails\templates\rails\mailers\email.html.erb

Is it possible to override this file somehow, and if so where?

[![Screenshot of where I want the metadata](https://i.stack.imgur.com/7gJIK.png)](https://i.stack.imgur.com/7gJIK.png)

Answer: 
Thanks for your time and interest. I try use replace(@myvalue, '''', '''''''') and it works fine. I'm sorry...
Lose the SELECT statement and just use a CASE:

```
SELECT
    OtherStuff
    ,CASE @myVar 
        WHEN '4' THEN '1'
        WHEN '18' THEN '2'
        WHEN '20' THEN '2'
        WHEN '5' THEN '5'
        WHEN '8' THEN '6'
        WHEN '21' THEN '7'
        WHEN '16' THEN '9'
        WHEN '7' THEN '10'
        WHEN '22' THEN '11'
        WHEN '34' THEN '11'
        WHEN '11' THEN '12'
        WHEN '10' THEN '13'
        WHEN '9' THEN '14'
        WHEN '13' THEN '15'
        WHEN '3' THEN '20'
        WHEN '17' THEN '22'
        ELSE '1'
    END,
    (...other fields values...)

```