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 -> newbie:sql trim() in where clause not working

newbie:sql trim() in where clause not working

From: joes <joes_at_bluewin.ch>
Date: 14 Jul 2006 07:16:36 -0700
Message-ID: <1152886596.676552.198530@h48g2000cwc.googlegroups.com>


Hi

I have somestring entries which consists only of spaces. I like to get rid of those entries but I can not "select" them. Both examples will not return anything

select * from tableA where trim(field1) is NULL select * from tableAt where trim(field1) = ''

Best options would be to do this during the importing job, unfortunately I can not repat this import. So any other suggestions?

Many thanks in advance

regards
Mark Received on Fri Jul 14 2006 - 09:16:36 CDT

Original text of this message

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