using this exampleUPDATE Aircraft SET CN = '*' where (CN = '' or CN is null) 
and MyPrimaryKey='xyz';can you substitute another column name iso MyPrimaryKey 
if the column you wantedto reference to wasn't the primary key, for example the 
field in a column named AT,as in:UPDATE Aircraft SET CN = '*' where (CN = '' or 
CN is null) and AT='xyz';mtia Mark
CDN Mark <cdn.mark at virgin.net> wrote:
> what I need to do is replace blank fields in a specific row, sort of
> a double where where statement as in:
> 
> UPDATE Aircraft SET CN = '*' where CN = '' or CN is null where (primary key)
> is xyz

UPDATE Aircraft SET CN = '*' where (CN = '' or CN is null) and 
MyPrimaryKey='xyz';
-- 
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to