Hi
I'm trying to make an update query for multiple data and no success. The problem is this.
Names
Agent mary
ag. roger
agentus jhonny
ca. mary
ca. roger
ca. jhonny
I want to transform ca. mary in agent mary, ca. roger in ag. roger, ca. jhonny in agentus jhonny in a single update query.