On 23 May 2013, at 7:06pm, Jill Rabinowitz <[email protected]> wrote:
> Does anyone know how I can check the column and set it to a value if it has > nothing in it? UPDATE myTable SET firstname='xxx' WHERE LENGTH(firstname) = 0 OR firstname IS NULL Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

