Ken wrote: > 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?
Did you try it? What database are you using? the query you posted will definatly work in some cases, like MSSQL. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230112 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
