Skip to Content
0
Former Member
Nov 10, 2006 at 10:53 AM

Set field value to null

3180 Views

Hi - I have appended a single character flag field to table equi (using the append structure) - Using a select statement I can return all records where this field has nt been populated by using the select statement:

select * from equi where zz_flag is null

However if I populate the field BUT then want to return it to null I am unable to do so i.e.

update equi set zz_flag = null where zz_flag = 'X'

returns the error 'Field NULL is unknown' . Using CLEAR sets the field to an empty string. How do I set this field back to NULL? Thanks