[sqlite] Using Like

[Roger]

hwo do i use LIKE in sqlite

eg in

Select Surname
from people
where surname like A* etc.