>

>CREATE CURSOR states ( st c(2) )
> INSERT into states VALUE('KS')
> INSERT into states VALUE('MO')
>
>CREATE CURSOR widgets (st c(2), misc c(3))
> INSERT INTO widgets values( 'KS', 'ABC')
> INSERT INTO widgets values( 'KS', 'DEF')
> INSERT INTO widgets values( 'KS', 'GHI')
> INSERT INTO widgets values( 'MO', 'ABC')
>
>I want to see the data as follows:
>
>  St    Widgets
>  ---   -----------
>  KS    ABC|DEF|GHI
>  MO    ABC
>
>Can this be done in SQL?
>

In VFP9 no without using UDF in SQL, which is not a good practice. AFAIK this question was discussed here, give me a sec. to find the solution.

I think there are some ways to do it in SQL Server, I saw this question discussed, but don't remember the solution off hand.