Advanced Search

Return to Snippet

Revision: 6428
at May 20, 2008 17:50 by mcbutterbuns
Initial Code 
DECLARE @IDlist varchar(100)
SELECT @IDlist = COALESCE(@IDlist + ', ', '') + CAST(id AS varchar(5)) FROM tbl
SELECT @IDlist
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Comma-Delimited List using Coalesce

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, list

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL