• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL server Management Studio

E

EmpHector

Junior Member
hi i have a problem in concatenating two different columns into a single new empty column.
i have a table as fallows
P_id Last name firstname address city New_address
1 Hansen ola Timoteivn 10 Sandnes NULL
2 Svendson Tove Borgvn 23 Sandnes NULL
3 Pettersen kari storgt 20 Stavanger NULL


in this table the column new_address is empty column i want the sql query to produce following output

P_id Last name firstname address city New_address
1 Hansen ola Timoteivn 10 Sandnes Timoteivn 10,Sandnes
2 Svendson Tove Borgvn 23 Sandnes Borgvn 23, Sandness
3 Pettersen kari storgt 20 Stavanger storgt 20,Stavanger

how to concatenate the column address and city together and put it in the column new_address....

Please help

thanks in advance ...

 
You must log in or register to reply here.

TRENDING THREADS

Back
Top