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
name
--- ---
1 George Handin
2 Joe Rachin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
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
