hi there, thanks Simon and Igor for your help on this a few weeks ago, but I need an addition to
UPDATE Aircraft SET CN = '*' where CN = '' or CN is null; what I need to do is replace blank fields in a specific row, sort of a double where where statement as in: UPDATE Aircraft SET CN = '*' where CN = '' or CN is null where (primary key) is xyz What I'm trying to do is update a database, but the users also have an automated update system that apparently if it finds any blank fields in the row, updates the whole row, thereby overwriting what I've replaced. I thought if I could at least replace the blank fields with something, it should prevent the overwriting. I don't know which fields are blank, every user will be different, so the plan was to update the fields I want to, insert text/symbol into the blank fields and leave the others alone. I realize that because I don't know which fields are empty/blank I'm going to have to create a statement for every column I'm not updating to, there are only 10 columns altogether and I'll typically be updating to at least 5 of them. hope this is clear and mtia Mark _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
