Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> newbie:sql trim() in where clause not working
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
![]() |
![]() |