And Here they Are.... The responses that I believe are all posted to the list.
________________________________________________________________________ _______________________________________________________ Info and an answer - I think the INSTR function returns an integer instead of a string. Does the search maybe work as follows: WHERE: (PIPARCELTYPE1 like "%CROWN%" AND OWNER = "") OR (PIPARCELTYPE1 like "%ROAD%") OR (PIPARCELTYPE1 like "%RAIL%") ________________________________________________________________________ _______________________________________________________ Try this! (InStr(1,PIPARCELTYPE1,"CROWN") > 1 And OWNER1 = "") Or InStr(1,PIPARCELTYPE1,"ROAD") > 1 Or InStr(1,PIPARCELTYPE1,"RAIL") > 1 ________________________________________________________________________ _______________________________________________________ Information re Instr - InStr returns Integer not Logical ---- so you need "Instr(..) > 0" ________________________________________________________________________ _______________________________________________________ -----Original Message----- From: R. Prest [mailto:[EMAIL PROTECTED] Sent: Friday, 30 September 2005 3:11 PM To: Carolyn Bergin Subject: RE: MI-L SQL - Or / And Hi, Best when you post this type of "thanks" message would be to enclose the answers you got (synthetised), so we can all share them... ;-) Thanks, Robin. -----Message d'origine----- De : Carolyn Bergin [mailto:[EMAIL PROTECTED] Envoye : vendredi 30 septembre 2005 06:26 A : Carolyn Bergin; Mapinfo-L Objet : RE: MI-L SQL - Or / And 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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18079
