If you are using SQL 2K5 and good in CLR, and CLR procedure deployment is possbile. Then go for that. String concatenation is faster in .Net. But in your case I think as you are using ASP, so I dont think it is possible. Or Use one scalar UDF, that will concatenate your string values. In that way you...