Thanks. It is a table with 50000 records. I know that I can do it quickly in VFP. Because the task seems quite simple I hoped that I can do it in an easy way in T-SQL.

>There's nothing built into TSQL to do this. If you're not dealing with a ton of data, it'll probably be easier to handle iteratively outside the database.
>
>-Mike
>
>>I have a table like this (on SQLServer) ?
>>
>>field1 (int) field2 (char)
>>1 aaa
>>1 bbbb
>>2 ccccc
>>2 bb
>>2 dd
>>2 hh
>>
>>How to get such results using T-SQL statment ?
>>
>>field1 'sum' of field2
>>1 aaa bbbb
>>2 ccccc bb dd hh
>>
>>
>>Thanks in advance