Try

SELECT case, STR(SUM(VAL(v3))) AS v3, STR(SUM(VAL(v4))) AS v4;
  FROM mytable GROUP BY case ;
  ...

You can use < pre > and < /pre > tags (w/o spaeces) to preserve formatting.

>Is there anyway to group data before sending to an excel spreadsheet. Below is an example of the data and the format that I am trying to send to excel.
>
>.dbf(all fields and variables are characters):

>case	v3	v4
>a	105	
>a		105
>b	225	
>b		225
>
>excel(this would be the format I want to get):
>
>case	v3	v4
>a	105	105
>		
>b	225	225
>		
>
>But this is what I get in excel instead:
>
>case	v3	v4
>a	105	
>a		105
>b	225	
>b		225

>Anyone have any ideas? I have played around with the Select command and have not been successful.
>
>Thanks,
>
>Kimberly
>
>Hope you will able to understand this because when I preview this it changes my format.