Hi Steve,

You can use the LIKE condition (like Sergey explain to you), or you can use SUBSTRING.

Select * from myTable Where substring(lastname, 1, 1) = 'L'


Cheers,

Ricardo