In MSSQL: update authors set city = city+'s' where au_lname = 'Smith'
> -----Original Message----- > From: Ken [mailto:[EMAIL PROTECTED] > Sent: Friday, January 20, 2006 9:49 AM > To: CF-Talk > Subject: SQL Update > > Hi. This may be a little elementary, but here it is: > > I want to update a database field so that all values in it > are appended with > a given string. Something like this: > > UPDATE db_names > SET db_names.lastName = db_names.lastName + 'Customer' > > I know the above query is wrong. Can someone tell me how to do it? [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230110 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
