The LIKE connective compares the data in a specified attribute to an alphabetic string. Unlike the string searching feature described in the preceding section, however, the LIKE connective requires the data to be merely phonetically similar to the specified string. This type of selection expression is particularly useful if the user is not sure how the data is spelled.
For example, this query searches for customers whose last name is something like PIERCE:
|
>LIST CUSTOMERS WITH LAST-NAME LIKE "PIERCE" LAST-NAME FIRST-NAME |
||
|
|
|
|
|
PAGE 1 |
10:56:57 DD MMM YYYY |
|
|
|
|
|
|
CUSTOMERS... |
Last Name... |
First Name |
|
|
|
|
|
SPIRS5289 |
PIRS |
SANDRA |
|
JPEER5993 |
PEERCE |
JAN |
|
RPIER5539 |
PIERCE |
RICK |
|
|
|
|
|
3 ITEMS LISTED. |
|
|
|
|
|
|
|
> |
|
|
Only one alphabetic character string may be specified after the LIKE connective in an INFO/ACCESS query.
See Also