11-28-2012 02:49 PM
I have a question about this code:
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"?
Need further help from the community? Please ask a new question.