Community discussion forum

convert EMPTY fields to NULL?

• • Reply

  8 months ago

  by karan_21584

  karan_21584

  Chennai, India

  Joined 1 year 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
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  7 months ago

  by pramos.21d

  Pramod Kumar

  , India

  Joined 2 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

  7 months ago

  by karan_21584

  karan_21584

  Chennai, India

  Joined 1 year ago

  can u post the query plz

  Report abuse
• • Reply

  6 months ago

  by comsc

  comsc

  , Thailand

  Joined 11 months ago

  Hmm, try this..

  update urTable set urField=NULL where urField=''

  Hope I can be of help... ü

  Report abuse