Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie:sql trim() in where clause not working

Re: newbie:sql trim() in where clause not working

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Jul 2006 22:17:52 +0200
Message-ID: <2vufb2dsegu56ra6513rd14m1fpho1hhh9@4ax.com>


On 14 Jul 2006 13:00:03 -0700, "akkha1234_at_gmail.com" <akkha1234_at_gmail.com> wrote:

>alternatively, try
>
> select * from table a where length(trim(field1)) = 0

Please do not top post

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Jul 14 2006 - 15:17:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US