I am using 'Like' in a sql query for a text field but not able get that to work. Here is what I am doing

SDescription = "'" & Text1.Text & " *'"

"SELECT * FROM TABLE WHERE DESCRIPTION LIKE " & SDescription