Lee, Thanks...
I also found a "BETWEEN" condition, so I'm thinking this is also a possibility. Best, Steve -----Original Message----- From: Lee Hinde [mailto:[email protected]] Sent: Monday, January 22, 2018 11:17 AM To: [email protected]; 4D iNug Tech <[email protected]> Subject: Re: 4D SQL Question DELETE FROM users WHERE id in [1,2.3]; would delete the three users with one of those ids (or none at all, if the ids didn’t exist.) DELETE FROM users WHERE last_name=“Smith”; would delete all users with the last_name of Smith. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
