On 12/22/2010 6:55 PM, CDN Mark wrote: > I tried using a statement > UPDATE Aircraft SET CN = "*" where CN = ""; > as a test which worked, but not for all records. I don't know if the blank > fields are empty or null
I'm not sure I understand the problem. If you are asking how to check both for an empty string and null, just do UPDATE Aircraft SET CN = '*' where CN = '' or CN is null; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users