concatenate columns
here's the query for concatinating the lastname and firstname in name field: update clients set name = concat(firstname, ' ', lastname) (or) update clients set name = concat(lastname, ' ', firstname) (or Where data has been added to a existing list) update clients set name=concat(firstname,' ',lastname) where name is null and length(firstname)>0 or length(lastname)>0 limit 2000000Related Articles
- List Won't Import (ListMaker Pro)
- "Failed to Open Rowset…" error in WebReports.
- Dial Result Codes for SpitFire Predictive
- How to Combine columns in Microsoft Excel
- What are the DialResult codes for SPX?
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "concatenate columns"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
20th of August, 2008
