On 23 Dec 2010, at 12:19am, Mark wrote: > ran the first example, came back with lots of lines, second test with the > just the 10 returned > 9 lines as 0: the second line as 2:3832, don't understand the > purpose/meaning of this
If that's 2 in the first column then those fields which you think contain blanks actually have two characters in them. So is that a legitimate thing for your cn to have ? Are their any legitimate values for cn which are less than three characters long ? If not, you can run something like UPDATE Aircraft SET CN = '' where length(cn) < 3 and that will make sure they're all really blank. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users