I want to be able to change the results that are output from a query like so.
select field
from table
if field = 'Stuff' then 'Junk'
elseif field = 'Crap' then 'Darn'
Since I am not quite sure what to look for, I have been unable to find anything in the docs. Select case doesnt seem to do what I want, but maybe I just dont understand.
Thanks
Chad