SQL Case-function problem: best way to leave one value alone?

[EinarRoed]

I have a question about this code:

case VARNAME

when "Oil and Penguins" then "Oil and Penguins"

else propcase(VARNAME) end

It puts all the values in the VARNAME column into proper case, but makes an exception for "Oil and Penguins" because it shouldn't become "Oil And Penguins". It works correctly, but I strongly suspect that the second line is a bit clumsy. Is there a better way to tell it to leave "Oil and Penguins" alone? Something along the lines of "when 'Oil and Penguins' then nothing"?

[PGStats · Accepted solution]

I guess

case VARNAME

when "Oil and Penguins" then VARNAME

else propcase(VARNAME) end

would be a tad neater.

PG

[EinarRoed]

Can't believe I overlooked doing that. :smileyshocked:

Thanks!