Bill writes "In one table, I have a column "FooBar" that holds a comma-delimited list of letter codes, like this:
ID FooBar
-- -------
1 b,d,c,e
2 a,d
3 d,c,b
Each letter is a code for a word or phrase, which is in a second table, like so:
Code Word
-- --------
a Red lips
b Green apples
c Blue waves
d Yellow daisies
e White clouds
How do I replace the letter codes with their equivalent words in column FooBar, like so:
ID FooBar
-- ------------
1 Green apples,Yellow daisies,Blue waves,White clouds
2 Red lips,Yellow daisies
3 Yellow daisies,Blue waves,Green apples
Thanks much!"
Replacing values in CSV lists 
Posted - 2001-04-01 : 11:07:39