Re: Using SQL to replace a quote in a character string

Hi everyone
We are on V7r3
I need to replace double quotes (") and commas (,) in strings with a space
I know I can use replace
Select REPLACE(a.bfname, ',', ' ') as New_Bfname from file a
Select REPLACE(a.bfname, '"', ' ') as New_Bfname from file a

My predicament is to replace quotes (') in strings with a space
Any idea how that can be achieved?
AND
Is there a way to incorporate ALL the changes in one go

E-mail : ASHORE@xxxxxxxx<mailto:ASHORE@xxxxxxxx>
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com