SQL Update data in a column
Datebase is Produce_Deliveries
Table is Transactions
Column is Customers
Data is John Smith
I would like to change all instances of John Smith to Julie Anderson
Table is Transactions
Column is Customers
Data is John Smith
I would like to change all instances of John Smith to Julie Anderson
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Scott Pletcher
Sounds like homework?! Is a real business really storing the actual client name in a transaction record?!
ASKER
Sorry Scott, Im not sure I understand your question and/or concern.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ahh, no, I know it is simple but it was easier to ask then figure out. It is for a scale program at a company I work at.
Thanks!! :-)
Thanks!! :-)
ASKER
When he said "Home work" all I could register was "Working at home" Which I was doing and couldnt quite figure out how scott could have known this. ;-)
ASKER
Ok, so this is what stired my initial question.
The query above doesnt seem to work. This is what I get.
experts.png
The query above doesnt seem to work. This is what I get.
experts.png
ASKER
And this is the table format
experts-table.png
experts-table.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
BEAUTIFUL!! Thanks!!