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]
