Thanks for the speedy response. Unfortunately, it's not seemingly possible to do...
UPDATE tab SET col = (SELECT dflt_value FROM (PRAGMA table_info(tab))); ... which certainly does make it a pain. Plus this doesn't work anyway where dflt_value is not a constant, but an expression (e.g. "current_date + 10"). Perhaps, I might see if I can't add the feature instead... Thanks again for your help! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users