LIKE
| All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/Components for this Example |
Function SET189K or form S_189FK
Use LIKE to retrieve records that match generic criteria. The % sign is used to represent any possible character:
SELECT_SQL FIELDS(#SURNAME) FROM_FILES((PSLMST)) WHERE('SURNAME LIKE ''B%''')
Use LIKE to retrieve records that match generic criteria. The % sign is used to represent any possible character:
SELECT_SQL FIELDS(#SURNAME) FROM_FILES((PSLMST)) WHERE('SURNAME LIKE ''B%''')
| Type | Name | Code | Description |
| Function | SET189K | SET189K | SELECT_SQL - (NOT) LIKE |
| Form | S_189FK | S_189FK | SELECT_SQL - (NOT) LIKE |