Re: what value to use in NVL for columns that may contain a NULL

From: NeelSing <bytetwo_at_hotmail.com>
Date: 14 Sep 2001 12:49:30 -0700
Message-ID: <d3852a1b.0109141149.1ff55471@posting.google.com>

Thanks for the replies.

I can do like this

   SELECT NVL( db_field, "\0"),

and then my string comparison viz

   strcmp(var_db_field_read_in, "") == 0 works ok.

I understand the use of indicator variables, I was looking for some new ideas.

Thanks for your replies again.

> > "NeelSing" <bytetwo_at_hotmail.com> wrote in message news:d3852a1b.0109131031.66eb3eef_at_posting.google.com...

> > > In Pro*C,
> > > EXEC SQL DECLARE myCursor CURSOR FOR
> > > SELECT NVL( db_field, ??),
> > >
> > > ...
> > > ...
> > > so that I may detect the value read as an empty string
> > >
> > > strcmp(var_db_field_read_in, "") == 0
> > > ...
> > > Please suggest.
> > >
> > > Cheers!
Received on Fri Sep 14 2001 - 14:49:30 CDT