• Hi ,

    You can get the desired result quiet easily...

    The below mentioned code will solve your problem.

    Select ID, Name, 'The City name is ' + Name Comment

    From #tTemp1