Skip to content
WILD CARD LIKE

Tasks

Simple search using equality (=)

Find customers who live in Edinburgh or in Glasgow

Pattern matching search using like

Find customers whose surname begins with A or with B
Find customers whose surnames end in the letter i
People who live in a flat have a house number with a / in it
Find customers who have a hyphenated surname
Display a list of people with surnames such as McIntosh, MacIntosh
Find postcodes that begin with exactly two characters, eg W3 8GS
Find customers with a 3 letter firstname
Multi-stage routes will have a 3 letter code, display all the multi-stage routes only.
Display route which have two stops
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.