Home » Developer & Programmer » Forms » updating a null value
updating a null value [message #78963] Mon, 08 April 2002 10:49 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Anyone know the syntax for 'where null update'? I've never used it before and can't find the syntax... I am trying to update a column in a table called comments, but the column is currenlty blank for some records and it's not letting me update it with a simple update statement!

Thanx
T
Re: updating a null value [message #79018 is a reply to message #78963] Sun, 14 April 2002 21:43 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
hi,
try using this

update table_name
set column_name = your_value
where column_name is null

hope i've understood ur problem and given u a solution

cheers
ram
Previous Topic: Re: Text List Order By
Next Topic: URGENT-FAIL UPDATE IN TRIGGER
Goto Forum:
  


Current Time: Fri Aug 14 10:00:13 CDT 2020