Why not...
Instr( 1 , description ,"Spring") = 0 AND (
Instr ( 1 , description , "Sink")>0 Or
Instr ( 1 , description , "Upper origin")>0 Or
Instr ( 1 , description , "Exiting water body")>0 )
>>? I can't fit all of them individually into the query
??
Emmanuel Par�
GIS/Programming for DBX Geomatics
email:[EMAIL PROTECTED]
http://www.linux-mandrake.com
-----Original Message-----
From: Tim Warman <[EMAIL PROTECTED]>
To: Mapinfo-L <[EMAIL PROTECTED]>
Date: 13 septembre, 1999 14:25
Subject: MI another SQL question
>Thanks to everyone for the help with the SQL question. Strangely, using the
>% wildcard doesn't seem to work, although the Instr function works great.
>Now I need to do a slightly more complex query which I've written as
>
>Instr( 1 , description ,"Spring")=0 AND Instr ( 1 , description , ("Sink"
>OR "Upper origin" OR "Falls" OR "Exiting water body")) > 0
>
>but although the syntax verifies fine I get an error message with "Instr:
>argument 3 has invalid type".
>
>Is it just not possible to group all the possible field values within a
>single Instr function? I can't fit all of them individually into the query
>window.
>
>TIA.
>
>Cheers,
>Tim
>_____________________________
>Tim Warman
>Geologist & GIS Specialist
>Richard C. Slade & Associates
>North Hollywood, CA
>(818) 506-0418
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
