|
-
January 5th, 2009, 03:46 PM
#1
Query Results with commas b/w fields
Ok, so I want to execute this query:
Select user_id, f_name, l_name
from tableABC;
And I want it to return in this format:
abc123, Joe, Smith
sid938, Mel, Ward
iic837, Al, Jamison
I want the returned fields to be separated by commas. How would I modify the sql query to make this happen? I've seen it done elsewhere, but I'm not a dba guy and thought someone here might be able to quickly tell me how to do this.
Not sure if it matters, but this is on sql server.
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|