For other newbies' benefit: Yes, indeed, importing empty columns doesn't set
them to NULL.
UPDATE Shops SET "contact:postcode" = NULL WHERE "contact:postcode" = "";
UPDATE Shops SET "addr:postcode" = NULL WHERE "addr:postcode" = "";
SELECT name, IFNULL("contact:postcode","addr:postcode") zipcode from Shops
where id="251373376";
Acme;12345
--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
