Find-and-replace substring in stored procedure

Does anybody have Find-and-replace stored procedure readily available to replace a substring with another one in an lvarchar field? Thanks in advance... Pascal Van Hecke TeleAtlas Belgium

It's not very clean, but you can replace a car by another using this : FOR i = 1 TO 255 IF str[1] = '' THEN EXIT FOR; END IF; IF str[1] <> 'a' THEN LET mytarget=mytarget || str[1]; IF str[1] = 'a' THEN LET mytarget=mytarget || 'a'; LET str = str[2,255]; END FOR; I'am interested for any other solutions too ... Pascal Van Hecke a 'crit dans le message <37283A24.55A73854@teleatlas.com>... >Does anybody have Find-and-replace stored procedure readily available to >replace a substring with another one in an lvarchar field? >Thanks in advance... > >Pascal Van Hecke >TeleAtlas Belgium >