How to insert null

[Harish]

How can we insert the null vales into the table..?
insert into test (4,NULL)
or
insert into test (4,'&#39

is this the right format..?

first one is correct.

------------
Harish at 9/20/01 2:44:58 PM

How can we insert the null vales into the table..?
insert into test (4,NULL)
or
insert into test (4,'&#39

is this the right format..?

[venkat]

I think second one is right



------------
Harish at 9/20/01 2:44:58 PM

How can we insert the null vales into the table..?
insert into test (4,NULL)
or
insert into test (4,'&#39

is this the right format..?

[Yads]

Dear venkat

Second one will insert a empty string. (empty string is not a null value)

try the following thing:

create table test1 (
col1 char(5) null
)
insert test1 values('&#39
insert test1 values(null)
insert test1 values('1&#39

select * from test1 where col1 is null

Thanks
Yads


------------
venkat at 10/12/01 7:45:20 PM


I think second one is right



------------
Harish at 9/20/01 2:44:58 PM

How can we insert the null vales into the table..?
insert into test (4,NULL)
or
insert into test (4,'&#39

is this the right format..?