Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie:sql trim() in where clause not working
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 DBAReceived on Fri Jul 14 2006 - 15:17:52 CDT