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 |
|
Scott
Posting Yak Master
145 Posts |
 Posted - 2001-11-12 : 02:16:29
|
| How do I update a third field througout the database to have the value of 2 fields joined together.eg:field1 | field2 | field3------------------------test | data | test datatest1 | data1 | test1 data1Sorry easy one,update table set field3 = field1 + ' ' + field2' ' adds a space between the 2 fields.Edited by - scott on 11/12/2001 02:37:23 |
|
|
|
|
|
2 field Concatenation