convert EMPTY fields to NULL?

sql server India
  • 9 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?

  • 9 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.

     

     

     

     

  • 9 years ago

    can u post the query plz

  • 9 years ago

    Hmm, try this..

    update urTable set urField=NULL where urField=''

    Hope I can be of help... ü

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Some people, when confronted with a problem, think "I know, I’ll use regular expressions." Now they have two problems.” - Jamie Zawinski