Hi Tom,
Not w/o UDF. See
Re: How To: Group Data and club a field of the group using S Thread #
763525 for sample code.
>
>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?
>
--sb--
