Wildcards - MapBasic - 2023

MapInfo MapBasic Reference
Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapBasic
Version
2023
Language
English
Product name
MapBasic
Title
MapInfo MapBasic Reference
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:32:32.686312

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