On 22 Dec 2010, at 11:55pm, 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
Do a SELECT length(CN),hex(CN) FROM Aircraft if that produces too many lines do SELECT length(CN),hex(CN) FROM Aircraft WHERE length(CN)<3 LIMIT 10 Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users