And isn't that what it should do?

Mark

-----Original Message-----
From: Tom Grenier [mailto:tom(at)sqlman.com]
Subject: Re: sql syntax

Ah yes, the NVL.  Now a days I work primarily in Oracle, but I still think
in
Informix (which has no equivalent to NVL so I'm used to doing a lot of
coding
for nulls).

However, I just tried this in Oracle (8i), and it does not null out the
whole
thing (e.g. if col1 is 'aa', col2 null and col3 'cc', one_column becomes
'aacc').

Tom

> >
> > > I am trying to figure out the correct way to update a
> > > column based on another columns.
> > >
> > > I nned to move the values from 3 columns into one
> > > column.  I.e.
> > >
> > > column 1 = college
> > > column 2 = child
> > > column 3 = <null> (or a value)
> > >
> > > into one column
> > >
> > > column a = college, child ...
> > >
> > > Any ideas ?
> > >
> > > _

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA