1.8.1 Example 1: Retrieve customers whose name begins with M

Retrieve from the customer table (USERSLIST) the customer ID (USERID), name (NAME), and sex (SEX) of customers whose name begins with M.

Table to search

[Figure]

Specification example

SELECT "USERID","NAME","SEX"
    FROM "USERSLIST"
        WHERE "NAME" LIKE 'M%'

Retrieval results

[Figure]