LIKE is a connective that selects items with a data element that sounds like the specified constant. The LIKE connective converts an alphabetic text string into a phonetic equivalent based on a Soundex algorithm.
For information about the Soundex algorithm, see the section entitled Statement and Function Reference.
Example
This example lists customers whose last names are phonetically similar to PIERCE:
|
>LIST CUSTOMERS WITH LAST-NAME LIKE "PIERCE" LAST-NAME FIRST-NAME STREET CITY STATE |
|||||
|
|
|
|
|
|
|
|
PAGE 1 |
|
|
11:23:24 DD MMM YYYY |
|
|
|
|
|
|
|
|
|
|
CUSTOMERS |
Last Name |
First...... |
Street......... |
City........ |
State |
|
|
|
|
|
|
|
|
SPIRS112A |
PIRS |
SANDRA |
112 APPLEBEE RD |
WINSTON |
NC |
|
JPEER89RIA |
PEERCE |
JAN |
89 RIALTO WAY |
LOS ALTOS |
CA |
|
|
|
|
|
|
|
|
2 ITEMS LISTED. |
|||||
|
|
|
|
|
|
|
|
> |
|
|
|
|
|
See Also