If i want to set a text value in the database to null how should I pass that in the UPDATE Statement ?
I tried these and didn't work --

Update val = ' '
Update val = NULL
Update val as NULL
Update val = "' '"

This has been bugging me for the past few minutes so I appreciate if any one can show me the way. Thanks