On 26 Nov 2002 at 16:02, Savita 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.
Umm.. Is this a text field? What happens when you select for string length=0?
IMO for a string/char field, NULL will be different than empty string but I am
still puzzled why '' did not work...
Bye
Shridhar
--
QOTD: "Our parents were never our age."