Could you write an SQL statement such as:

Select * from tablename where lastname = 'a%'

would this extract all records from the table with lastname beginning with'a' rather than using the LIKE key word?