Is it possible to add a value in a temp_table during a query?
Kind of like fieldname AS whatever.....but instead of changing the column name it chages all the values in the column.
example:
select Id from table ID VALUE AS 'the value'
Did I explain this well.
In other words I want the temp table to replace the value of Id with whatever I choose...but I dont want it to alter the table...just the results.
