How to set column text when creating a view in SQL? By default, when creating a view, for the Text of each column, if the column is a direct selection from a table/physical file then it will use the Text of that table/physical file's column. If it's not (e.g. a CASE statement), then it's blank.

How can I override it to set what I want for the view's columns' texts?
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.