Combining names in SQL

Copper Contributor

 

I have a report I'm working on in power BI and I would like to combine Samantha Marshall who is now now Samantha Murphy. What is the query I should write?

-->I tried the following with no luck


Update
[Table name]
Set created_by = 'Samantha Murphy'
where created_by = 'Samantha Marshall'


Testbot1_1-1692708691040.png

 

0 Replies