Not really, but you *can* make a function to do it.
How are things in O.P.? Send some Hayward's BBQ!!!! hahaha

>

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