ODBC replace as

[bkames]

Hi,

sorry I`m very new to progress and I try something like this.

select Bu, replace (Ja,'2009','2010') AS Ja, Fi, ko from FB;

But I get

Incombatible Datatype (223)

 

[Casper]

Always good to state your Progress Version (or OpenEdge release..).

are you sure ja is an existing character field from the table?

For me this works:

select replace("fieldname",'000','111') from pub."tablename";

Casper.