Adding Null to a column

[Patrick Olurotimi Ige]

I'm trying to add NULL to a column in the database but the sql below
isn't updating?

if (name=="")
{
strCmd += "UPDATE";
strCmd += " EMPLOYEEDETAILS SET ";
strCmd+= "name='"+null+"',designation='"+desg+"',sex='"+sex+"'
,age="+age+" , salary="+salary+" where id="+id;
}

 

[Jignesh Desai]

Update TableName Set Column1 = null (No quotes)

HTH
Regards,
Jignesh Desai
www.dotnetjini.com

 

[Elton Wang]

Hi Patrick,

Use NULL without single quotation mark, e.g. SET name =
NULL .

HTH

Elton Wang
(e-mail address removed)

 

[Tampa.NET Koder]

Patrick,

Please try not to double post. If you looked at the post you made earlier
today at 1:53am then you would have gotten the answer to your question.