convert EMPTY fields to NULL?

• • Reply

  12 years ago

  by karan_21584

  kirubakaran

  Chennai, India

  Joined 14 years ago

  how to insert null to an EMPTY cell in SQL SERVER...

  i.e, in a field, i enter some values and deleted it. so, it is considered as EMPTY field and not null. i need a query to make that field <NULL>

  can anyone help me?

  Report abuse
• • Reply

  12 years ago

  by pramos.21d

  Pramod Kumar

  , India

  Joined 14 years ago

  Hi Karan,

  From my experience you can insert the null value to sql server by using "DbNull.Value" or "null". So far it worked for me..

  Regards,

  Pramod.

   

   

   

   

  Report abuse
• • Reply

  12 years ago

  by karan_21584

  kirubakaran

  Chennai, India

  Joined 14 years ago

  can u post the query plz

  Report abuse
• • Reply

  12 years ago

  by comsc

  comsc

  , Thailand

  Joined 13 years ago

  Hmm, try this..

  update urTable set urField=NULL where urField=''

  Hope I can be of help... ü

  Report abuse