is this even possible?

Hello,
I'm hoping someone in here can tell me if this is even possible and if
it is how I could do it.
I have a simple query that produces a result like so:
FName LName FullName
-- -- --
Joe Blow Joe Blow
Some Guy Some Guy
Frank Sinatra Frank Sinatra
However, I would like to get the data a to display like so:
FullNames
Joe Blow, Some Guy, Frank Sinatra
Any ideas?
-Scott
Try somthing like following:
declare @.tmp varchar(8000)
select @.tmp=isnull(@.tmp+',','')+fullname from (<paste your query here or use
temp table>) t
select @.tmp
James
"Scott Elgram" wrote:

> Hello,
> I'm hoping someone in here can tell me if this is even possible and if
> it is how I could do it.
> I have a simple query that produces a result like so:
> FName LName FullName
> -- -- --
> --
> Joe Blow Joe Blow
> Some Guy Some Guy
> Frank Sinatra Frank Sinatra
> However, I would like to get the data a to display like so:
> FullNames
> ----
> Joe Blow, Some Guy, Frank Sinatra
>
> Any ideas?
> --
> -Scott
>
>
|||James,
Thanks...That works!
-Scott
"James Ma" <JamesMa@.discussions.microsoft.com> wrote in message
news:BD15FBE6-6CB1-43D5-860F-AB4EE8837854@.microsoft.com...
> Try somthing like following:
> declare @.tmp varchar(8000)
> select @.tmp=isnull(@.tmp+',','')+fullname from (<paste your query here or
use[vbcol=seagreen]
> temp table>) t
> select @.tmp
> James
> "Scott Elgram" wrote:
if
> -- -- --
--[vbcol=seagreen]