I have a table 'SIZE' with structure as follow:

CODE C(10),
SIZE C(1),
SIZE_DESC C(10)

A sample set of data is shown below:

CODE SIZE SIZE_DESC

001 1 S
001 2 M
001 3 L
002 1 M
002 2 L
003 1 XS
003 2 S
003 3 L


I need to report the data into the following way:

CODE 1 2 3

001 S M L
002 M L
003 XS S L

How do I do this? If the 'SIZE_DESC' is numeric, I can do 'SELECT SUM(IIF(SIZE='1',SIZE_DESC,"") AS DESC1, .... GROUP BY CODE....'. But it is a character field, how do I do it?

Thanks in advance.