Re: Removing tabs in strings with PL/SQL
From: Patrick Ryan <pat_at_halcyon.com>
Date: 29 Jan 2001 21:03:14 GMT
Message-ID: <954lqi$dh9$1_at_brokaw.wa.com>
Date: 29 Jan 2001 21:03:14 GMT
Message-ID: <954lqi$dh9$1_at_brokaw.wa.com>
[Quoted] A better method is to use the REPLACE function
REPLACE (string, chr(20), ' ')
(I think tab is chr(20), you'll wanna check)
Happy coding!
gregteets_at_my-deja.com wrote:
> I have a column of text. Some of the strings in
> the table have tabs in them. I have been working
> with LTRIM in PL/SQL to remove the tabs but cannot get it
> to work.
> I assume I would set the second parameter to a
> tab, presumably using the ASCII code for tab.
> If someone has done this, please let me know how
> to do it.
> Thank you.
> Greg Teets
> Cincinnati, OH
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 29 2001 - 22:03:14 CET