Question on REPLACE

[safarijoe2000]

Hello,

This is a simple one.

In a table I have a column (columnA) where my data shows some "unwanted" characters. I would like to replace all these characters with some others.

For example, I have on columnA some fields with the name: O'Connor, which I would like to change to O#Connor.

Could I use the REPLACE statement, to change ALL the fields (actually part of a string within that field) on a certain column WITH some other character.

Any help will be useful.

Thanks

 

[csr]

Check out the STUFF() function.


Don

 

[ChrisRChamberlain]

safarijoe2000

REPLACE MYTABLE.fieldname WITH STRTRAN(MYTABLE.fieldname,['],[#]) ALL

FAQ184-2483 - the answer to getting answered.​

Chris

http://www.pdfcommander.com

http://www.pdfcommander.co.uk

 

[jimoo]

I have an faq that may assist. It doesn't use the replace, but you should be able to see it in action. I try to write my faqs so you can just copy the whole faq into a prg and run it.

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[jimoo]

Just like forgetting to attach a file.

Here is the faq: faq184-4326 Parsing Delimited Text

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com