MapInfo Products KnowledgeBase

Product: MapInfo
Version: 3.x\4.x\5.x
Platform: All Platforms
Category: SQL Select\Select

Summary:
Selecting multiple records with wildcards that have different strings.

Question:
How to select using a wildcard in SQL Select where it is desired to find records with two different search strings?

Answer:

The following SQL dialog shows how to select all State names with "ar" and "ne" in the State name using a wildcard.



Last Modified: 12/06/1998 09:07:24 PM
Document URL: http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/D8D859E95CE33F36852565FB00711385

Selecting multiple records with wildcards that have different strings.^D8D859E95CE33F36852565FB00711385^Y