Will this syntax work?

Posted in 1999

Keith Sharp — Thu, 02 Sep 1999 19:35:21 GMT — source: Informix-list mailing list archive (1991-1998)

delete from my_offices where title in ( 'senior vp','vp') or has_office = 1 ;

↪ replying to Keith Sharp

Christophe MAUMONT — Fri, 3 Sep 1999 08:41:47 +0200 — source: Informix-list mailing list archive (1991-1998)

Why not ? Keith Sharp a 'crit dans le message <01bef579$fd0a9650$9e10a8a5@emc2369>... >delete from my_offices >where title in ( 'senior vp','vp') >or has_office = 1 ;

↪ replying to Keith Sharp

M00n321 — 03 Sep 1999 08:21:27 GMT — source: Informix-list mailing list archive (1991-1998)

>delete from my_offices >where title in ( 'senior vp','vp') >or has_office = 1 ; It might be worth som research time to determine if the is and 'accepts responsibility for own actions' flag anywhere in the database. If so, it would be more efficient to delete where that flag is set false.