[SQL] Query to return modified results at runtime?

I have a query: SELECT * FROM testtable; Where the results are: IDColor --- --- 1 Blue 2 Red 3 Green 4 Orange How would I rewrite the query to return results where the colors are replaced by letters to give the following results? IDColor --- --- 1 A 2

[SQL] Concat two fields into one at runtime

name --- --- 1 George Handin 2 Joe Rachin ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [SQL] Query to return modified results at runtime?

Richard Broersma Jr wrote: IDColor --- --- 1 Blue 2 Red 3 Green 4 Orange How would I rewrite the query to return results where the colors are replaced by letters to give the following results? IDColor --- --- 1 A 2 D 3 B 4 C http://www.po