>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.

try iif(allt(str(size))="1".......