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