LIKE( ) Function Example

In the following example, all product names in the products table with the first two letters "Ch" are displayed.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE products  && Open Products table

CLEAR
? 'All product names with first two letters Ch:'
?
SCAN FOR LIKE('Ch*', prod_name)
   ? prod_name 
ENDSCAN
USE