Re: PLSQL String manipulation

You can use the replace function as

select replace(str,':','') from dual;

good luck,


"Faraz" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I am stuck in a place, don't have any books or manuals.
> How can I remove a certain character, for example semicolon, from a
string.
>
> Thanks