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

Reply via email to