Wildcards - MapBasic - 2023

MapInfo MapBasic Reference
Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapBasic
Version
2023
ft:locale
en-US
Product name
MapBasic
ft:title
MapInfo MapBasic Reference
First publish date
1985
ft:lastEdition
2023-09-12
ft:lastPublication
2023-09-12T16:32:32.686000

The LIKE operator uses the percent (%) and underscore ( _ ) characters as wildcards.

Wildcard Performs Example

_

matches one character

 
select * from table where Name Like "New Yor_" into Selection

%

matches zero or more characters

 
select * from table where Name Like "New%" into Selection