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