How to substitute text in the select statement output?
Posted on 2011-09-08
I have only numeric values in a table. I want the output of a select statement to show text values rather than the numeric values. Modifying the table is not an option. I need to perform the substitution entirely within the select statement.
select period, sum(sales)
Desired Output Example:
Table Data Example:
The actual data is much more complex, but a solution to the above should do it. Thanks in advance!