Ahh so it evaluates the expression with in the brackets first ( I vaguely remember my math's teacher mention this some 40 years ago, should have listened)
Regards John B -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 February 2004 21:23 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: AND + OR Logic On Thu, 12 Feb 2004, John Berman wrote: Try adding some ()s: > SELECT * FROM marriage WHERE (groom_surname like ('"& globsurname & "') or > bride_surname like ('"& globsurname & "')) and community like ('"& community > & "') > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]