Share
ReportI 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
You’re offline. This is a read only version of the page.
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?
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
