Following your suggestion, I change my data in my size_desc to numbers and select VAL(SIZE_DESC) as the third field. It works. It just shows that there is something wrong with my FPW26 but it doesn't help me. I need a character description.


Tai SC

>TRY VAL(Size_desc)
>
>JR
>
>>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.