TRANSLATE and REPLACE [message #276621] |
Thu, 25 October 2007 11:27  |
yerics
Messages: 89 Registered: August 2006
|
Member |
|
|
Hi,
I have a table with varchar2 field having values
IDSX***
ICAPA**
TXF4***
I want to replace only the 5th character of the above values to a 'Z'. When I use the translate and replace, the value changes to
IDSXZZZ (Required - IDSXZ**)
ICAPZ** (Required - ICAPZ**) <-- ok
TXF4ZZZ (Required - TXF4Z**)
Regards,
Prasanna
|
|
|
|
Re: TRANSLATE and REPLACE [message #276626 is a reply to message #276625] |
Thu, 25 October 2007 11:37  |
yerics
Messages: 89 Registered: August 2006
|
Member |
|
|
Thanks a lot.
I have learnt that Sometimes you tend to overlook some simple functions available and go searching for a complex solution to a problem.
Thanks again
|
|
|