Re: sql --> query for empty column

Perhaps the field you think has nothing in it actually contains spaces...

try the following:
select

        decode(substr(column_name,1,1),' ','space!!') from table_name;

good luck

Robert Prendin
crd_at_cs.odu.edu (CRAIG READ DUNCAN) wrote:

>Hi,
>I need to query for an empty column in a certain record.
>The column in question definitly has some empty entries.
>I've tried <''>,<null>,<blanks>, and length(column). All
>come back with no hits.
>
>These records were created with sqlloader, if that has
>anything to do with it. The particlular column either
>had a text string (varchar2) or nothing. What's the trick?
>I suspect this is basic stuff; I'm new at this.
>
>Solaris 2.51
>Oracle 7.3.3
>
>I'd appreciate any help,
>crd
Received on Fri Apr 10 1998 - 20:31:16 CDT