How do I get the results from three rows into one?

[christer99]

I know this is probably simple, but the query below may produce multiple rows of data (unless it is grouped). How do I get the result to be one row as one string, for example rowa.wordstring +rowb.wordstring + rowc.wordstring

SELECT OppName
FROM OpInfo
WHERE (GROUPOPID = 129)

 

[ca8msm]

There's a few ways. Here's the last time it was discussed: thread183-1366521



____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.