Procedure to replace Single Character in a String

RGAUGHRAN · #1 (**permalink**) 01-04-06, 10:54

Has anyone created a DB2 procedure or UDF that can Replace a character or characters in the middle of a Character String Column? If so, could you email me the code? Thanks, Rachel

ARWinner · #2 (**permalink**) 01-04-06, 10:58

Have you looked at the REPLACE built in function?

Andy

sun4u · #3 (**permalink**) 01-05-06, 05:19

Are you not familiar with REPLACE scalar function ?

http://publib.boulder.ibm.com/infoce...n/r0000843.htm

Rob den Heijer · #4 (**permalink**) 03-01-06, 06:25

Quote:

Originally Posted by RGAUGHRAN

Has anyone created a DB2 procedure or UDF that can Replace a character or characters in the middle of a Character String Column? If so, could you email me the code? Thanks, Rachel

Try this:
db2 values translate ('I wqnt q rxplqcxmxnt', 'ea', 'xq')
and tell me if it is what you want...

cheers,
Rob.

Internet Services

Web Development

Digital Marketing

Consumer Tech