1. harsh_sr New Member

   I've a table with following data
   
   DATA
   -----
   Red
   Blue
   White
   Yellow
   
   I want to fetch result as 'Red, Blue, White, Yellow' in a single SQL Query.
   
   How to do that?
   Thanks
   
   
   Harsh

   harsh_sr, Oct 28, 2004

   #2
2. FrankKalis Moderator

   What about
   
   
   DECLARE @allnotes VARCHAR(8000)
   SELECT
   @allnotes = ISNULL( @allnotes + ', ', '' ) + DATA
   FROM
   < your table >
   SELECT
   @allnotes
   
   
   
   -----------------------
   --Frank
   http://www.insidesql.de
   -----------------------
   

   FrankKalis, Oct 28, 2004

   #2
3. harsh_sr New Member

   It works...cool
   Thanks a lot Frank
   
   -Harsh

   harsh_sr, Oct 28, 2004

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in