MapInfo Products KnowledgeBase

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

Summary:
Finding records using like, not and the percent sign as a wildcard.

Question:
What are some examples of using Like, Not, and the Percent Sign (%) in queries?

Answer:
In this example, the following records will be used:



To query the table of schools above for any records having High School in the school name, use the percent sign (%) as a wildcard in front of the words High School as shown in the SQL dialog box below. This will return any record with the words High School in it.





(The % sign can also be used multiple times in a line such as: "%xxx%". This would return all records with the string before or after the letters xxx.)

To refine the query and find only High Schools and not Junior High Schools, use "not" as shown in the SQL dialog box below.







Last Modified: 07/25/2000 12:48:56 PM
Document URL: http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/325D4ABD1764709985256921004F840E

Finding records using like, not and the percent sign as a wildcard.^325D4ABD1764709985256921004F840E^Y