WHERE clause to specify a range of initial characters
The following query selects only those rows where the manu_code begins
with
A
through H
and returns the
rows that the result shows. The test '[A-H]
' specifies
any single letter from A
through H
,
inclusive. No equivalent wildcard symbol exists for the LIKE keyword.