Correct SQL syntax?

[trance4eva]

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?

[GaryMazzone]

No you need the Like Keyword the = sign would only match a% as a last name