How to set column text when creating a view in SQL?
Simple: use an alias

SELECT ... CASE something WHEN 'somethingelse' ... END AS whatever, ...


The above will have the alias of WHATEVER. You can even get fancy and quote the alias: 

... AS "Something Else"

which will have the alias of Something Else.