Yes, you can. Not in SQL though - as you can't determine in advance the
number of Look_Id's. You'll need a function, using a cursor to loop through
the records and concatenate the results. Then use the function in an SQL
statement. This what you want?
Radu
"Rangeshwara Reddy Kona" <konareddy_at_hotmail.com> wrote in message
news:3bec9657$1_at_news.cadence.com...
> Hi All,
>
> I have a lookup table which says
> User_tab
> 123
>
> User_ID Look_Id Set_property
>
> 123 1 yes
> 123 2 no
> 123 3. yes
>
> Can I return a single row line
> 123, 1, yes, 2, no, 3, yes
>
> Thanks in Advance
>
>
Received on Sat Nov 10 2001 - 04:08:19 CST
