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