I want to move some infomation in Customer by sql queries.
from "Account numner" to "last name".
is there anyway?
*This post is locked for comments
Hope you don't have more than one Smith as a customer!
Thank you it works
Lets do it backward.
UPDATE Customer
SET AccountNumber = LastName
Thank you for your reply
I tried but the query you posted did not work what it want
I want to MOVE Last name into Account Number.
UPDATE Customer
SET LastName = AccountNumber
Haemin, use this query. But this will update all your customers' last to their account number.
Make sure to backup your DB before you do this.
Yes i want to move account number into last name field.
I don't understand your question. Do you want to move Account Number data into Last Name field?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156