Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | shanmugarajPosting Yak  Master
 
 
                                        219 Posts | 
                                            
                                            |  Posted - 2013-04-16 : 09:55:13 
 |  
                                            | I have 2 parameters with different text and i want to get the different textstr_variable_1 = "Name,Gender,Age"str_variable_2 = "Name,Gender,Age,Dept_Id,Desig_Id"I need to return = str_QueryAlter table Employee Add Column Dept_Id int NOT NULL, Desig_Id int NOT NULLTHANKSSHANMUGARAJnshanmugaraj@gmail.com |  |  
                                    | visakh16Very Important crosS Applying yaK Herder
 
 
                                    52326 Posts | 
                                        
                                          |  Posted - 2013-04-16 : 11:00:45 
 |  
                                          | try using REPLACE------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |  
                                          |  |  |  
                                |  |  |  |