MapInfo Products KnowledgeBase

Product: MapInfo
Version: 4.x\5.x\6.x
Platform: Win9x\NT\2000
Category: SQL Select\Select

Summary:
Select using a wildcard.

Question:
Select using a wildcard.

Answer:
When?
· Don’t know the full string.
· Have several different targets that are similar (such as all states beginning with the letter “M”).

How?

1. Choose Query>SQL Select.

2. The like operator has two wildcards available: the “%” character and the “_” character. The “%” is used for any sequence of characters while the “_” is for any single character. The following query will select all states that begin with the letter “M.”

Last Modified: 12/11/2000 12:08:52 PM
Document URL: http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/8FC229D164DCE3B88525655300633442

Select using a wildcard.^8FC229D164DCE3B88525655300633442^Y