InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:09:31 GMT20http://www.sqlservercentral.com/Forums/Topic1364451-392-1.aspxAnother way is like this (a computed column):[code="sql"]IF object_id('TempDB..#tTemp1') IS NOT NULLDROP TABLE #tTemp1CREATE TABLE #tTemp1(ID int, Name varchar(20) ,Comment AS ('The city name is ' + Name))INSERT INTO #tTemp1(ID, Name)SELECT 1, 'NewYork'UNION SELECT 2, 'Virginia'UNIONSELECT 3, 'London'UNIONSELECT 4, 'Sydney'UNIONSELECT 5, 'Dubai'SELECT * FROM #tTemp1DROP TABLE #tTemp1[/code]Thu, 27 Sep 2012 19:13:21 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic1364451-392-1.aspxHi ,You can get the desired result quiet easily...The below mentioned code will solve your problem.Select ID, Name, 'The City name is ' + Name CommentFrom #tTemp1Thu, 27 Sep 2012 04:01:48 GMTard5karthickhttp://www.sqlservercentral.com/Forums/Topic1364451-392-1.aspxDid you know that in [i]any[/i] tiered architecture, not just SQL, that kind of display formatting is always done in a presentation layer? This tiered concept is usually covered in the first day of any class on the subject.Wed, 26 Sep 2012 01:38:20 GMTCELKOhttp://www.sqlservercentral.com/Forums/Topic1364451-392-1.aspxYep, just this easy:[code="sql"]IF object_id('TempDB..#tTemp1') IS NOT NULLDROP TABLE #tTemp1CREATE TABLE #tTemp1(ID int, Name varchar(20))INSERT INTO #tTemp1(ID, Name)SELECT 1, 'NewYork'UNION SELECT 2, 'Virginia'UNIONSELECT 3, 'London'UNIONSELECT 4, 'Sydney'UNIONSELECT 5, 'Dubai'SELECT ID, Name, 'The city name is ' + Name as Comment FROM #tTemp1DROP TABLE #tTemp1[/code]Wed, 26 Sep 2012 00:55:10 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1364451-392-1.aspxIts really a simple solution with all you need to do is add a column that conactinates the fixed string 'This city name is ' and the Name Column.Wed, 26 Sep 2012 00:36:28 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1364451-392-1.aspxHi..I have data the data in the below temp table(SQL query)[code="sql"]IF object_id('TempDB..#tTemp1') IS NOT NULLDROP TABLE #tTemp1CREATE TABLE #tTemp1(ID int, Name varchar(20))INSERT INTO #tTemp1(ID, Name)SELECT 1, 'NewYork'UNION SELECT 2, 'Virginia'UNIONSELECT 3, 'London'UNIONSELECT 4, 'Sydney'UNIONSELECT 5, 'Dubai'SELECT * FROM #tTemp1DROP TABLE #tTemp1[/code] I need the SQL query to get the output as:[img]http://www.sqlservercentral.com/Forums/Attachment12473.aspx[/img]Thanks..Wed, 26 Sep 2012 00:19:57 GMTetirem