SQL Statement

[levyuk]

How can I change this statement to select everything from employees where the lastname is LIKE something
I thought this would work but it doesn't, any help?

strSQL = "SELECT * FROM Employees Where Lastname='" & TextBox1.Text & "*'"

 

[Administrator]

WHERE LastName Like '" & TextBox1.Text & "%'"

 

[levyuk]

Cool cheers mate