Re: COPY COMMAND

Hi Tino,

These query does not work.

Tino Wildenhain wrote:

> Hi Savita,
>
> --On Dienstag, 26. November 2002 16:02 +0530 Savita <savita(at)india(dot)hp(dot)com>
> wrote:
>
> > Hi,
> > I am able to insert the null field using \N in the text file,but while
> > retiving the data I am not able to retrive it.
> >
> > After inserting data I tried this select statement
> >
> > select * from os_customer_master where updated_by=' ';
> > and
> > select * from os_customer_master where updated_by=null;
> >
> > but it gives 0 rows.then how will I select this values.
>
> Nothing to do with copy :)
> Just try:
>
> select * from os_customer_master where isnull updated_by;
>
> Regards
> Tino

--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------