Rplace sql query

[sdnprs]

How can I write a replace SQL query to replace a dash anywhere in a label field in a table with a space. The dash is an unsupported field and I have about 7000 records with dashes in various places within the particular field

 

[dnoeth]

update tab
set col =
substring(col from 1 for position ('-' in col) - 1)
|| ' ' ||
substring(col from position ('-' in col) + 1)
where position ('-' in col) > 0

repeat it until activity_count = 0

Dieter

 

[angiole]

If your dbms is Oracle you may try:

select Column1,
replace (Column1,'A','Z') New_Column1
from tablex

Giving:

Column1 New_Column1
--------- -----------------
ABC ZBC
CDB CDB
XYZ XYZ
AAA ZZZ

Cheers
AA 8~)