On 1/10/2011 5:04 PM, CDN Mark wrote: > using this exampleUPDATE Aircraft SET CN = '*' where (CN = '' or CN is null) > and MyPrimaryKey='xyz';can you substitute another column name iso MyPrimaryKey
You can substitute any logical combination on any set of columns in Aircraft table. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users