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?

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.

can u post the query plz

Hmm, try this..

update urTable set urField=NULL where urField=''

Hope I can be of help... ü