Thanks everyone. All suggestions worked.
Really appreciate it! -----Original Message----- From: Carolyn Bergin [mailto:[EMAIL PROTECTED] Sent: Friday, 30 September 2005 11:29 AM To: Mapinfo-L Subject: MI-L SQL - Or / And Hi List Im trying to query a table to find all entries that have the following conditions PIPARCELTYPE1 contains the string CROWN and for all of these Crown Parcels OWNER1 is blank OR PIPARCELTYPE1 contains the string ROAD or RAIL, I want to select all of these not just where the OWNER1 is blank Ive tried the following query but I end up selecting the correct crown parcels but only road and rail parcels where the owner is blank not all of them. (InStr(1,PIPARCELTYPE1,"CROWN") And OWNER1 = "") Or InStr(1,PIPARCELTYPE1,"ROAD") Or InStr(1,PIPARCELTYPE1,"RAIL") This is a query we will need to run often so I was hoping I could just do it all in one saved query. Thanks Carolyn Bergin GIS Operator Warren King and Company & Midland Survey Services 2 Victoria Street Midland, PERTH, W.A Australia 6056 Telephone: +61(08) 9274 2535 Fax: +61(08) 9274 2545 Email: [EMAIL PROTECTED] The information contained in this e-mail message and any attachments may be privileged and confidential. The contents are intended only for the recipient named in this message and any unauthorised use or disclosure is expressly prohibited. As no responsibility is taken for any loss or damage that may be caused by viruses you should scan any attachments for viruses before opening. If you have received this message in error, please notify us and then delete the document. Thank you. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18073 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18074
