[Updating Field to Null]

That's it. Thanks man.

[Updating Field to Null]

Hi,

I'm trying to change a field in my sql table back to NULL. (default). It's if the user enters info to the wrong row and wants to change back to NULL. The code I use changes the field to 0 when executed. I've searched for this here and online and I'm not sure what's happening. I could use 0 but curious to what's happening. Here's my code.

$delSQL = sprintf("UPDATE table SET field1='NULL' WHERE field2=%s",
GetSQLValueString($vr, "text"));

I would appreciate any pointers you can give me.
Thanks,
Gusty.