Hi,
I need a query that works exactly like find and replace function. I have tried many ways, but the result is always the same - the whole string gets changed, not just the character/s in need.
So if I need all "!" exclamation remarks changing to a "?" question mark it will do it.
So would change this:
Help!
Oi!
Hi!
Hello!
to
Help?
Oi?
Hi?
Hello?
Also note that I can't just do an update query to find
Help!
Oi!
Hi!
Hello!
and replace with:
Help?
Oi?
Hi?
Hello?
Its must only work on finding the ! and replacing with ?, just like find and replace.
Thanks
I need a query that works exactly like find and replace function. I have tried many ways, but the result is always the same - the whole string gets changed, not just the character/s in need.
So if I need all "!" exclamation remarks changing to a "?" question mark it will do it.
So would change this:
Help!
Oi!
Hi!
Hello!
to
Help?
Oi?
Hi?
Hello?
Also note that I can't just do an update query to find
Help!
Oi!
Hi!
Hello!
and replace with:
Help?
Oi?
Hi?
Hello?
Its must only work on finding the ! and replacing with ?, just like find and replace.
Thanks