Insert <NULL> into SQL

[manju]

Hi,

Am writing an update statement to one of my SQL tables. I have fields which are <NULL> I want them to remain so after the update. When I update they either become blank or Null.
How can I keep them <NULL>.

Any help would be appreciated.

[Superfly1611]

Shouldn't be happening
Show us your SQL statement

[manju]

If (AccountName = "") Then
SqlComm.CommandText = "UPDATE Accounts SET " + _
" Name = " + DBNull.Value + " WHERE AccountKey = " + AccountKey.ToString()
End IF

The above SQL statement inserts blank into the column.

[Superfly1611]

Do it in SQL.

"UPDATE accounts SET name = NULL where accountkey = " + accountkey.tostring()

syntax might be different for different databases but it works fine for me on MS SQL Server

[manju]

Thanks a lot...