Insert Query

[jeenajos]

Hi all,
I just want to insert a date in the column where it is null.I tried a query but its not working.

INSERT INTO TotalMessages
(ReqDate)
VALUES ('2/25/2008')
WHERE reqdate = NULL

Error near where clause.

Thanks in advance.

Regards.

[deepuv04]

Hi all,
I just want to insert a date in the column where it is null.I tried a query but its not working.

INSERT INTO TotalMessages
(ReqDate)
VALUES ('2/25/2008')
WHERE reqdate = NULL

Error near where clause.

Thanks in advance.

Regards.

you can not do that

use update statement

update TotalMessages set ReqDate = '2008-02-25' where reqdate is null


thanks

[jeenajos]

insert

Thank You for the help.

regards