SQL Statement

levyuk

Well-known member
Joined
Jun 7, 2004
Messages
313
Location
Wales, UK
Programming Experience
3-5
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 & "*'"
 
Top Bottom