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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 16:05:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.