Sorry. I was looking at the wrong data (asuming that size was size_desc).

If I'm understanding this correctly, you can either have 2 select commands, using integrated if (IIF()) statements -- Like IIF(Size ="XS",1,IIF(Size ="S",2,IIF(Size ="M",3,IIF(Size="L",4,IIF(Size ="XL",5,0))))) AS Size_numb, then doing another select, or integrating that long integrated if clause into your one select command.

JR

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