You need to put the wildcard before the value too:

"Select * from livros where autor like '*" & request.Form("texto") & "*'"

>Hi !!:
>I have a little problem , i try to make a query over a Access database SQLCons = "Select * from livros where autor like '" & request.Form("texto") & "*'"
>
>In this case request.Form("texto") = "Assis" and a name in the table is "Machado de Assis" too, and i no have any result.
>How can i make this query ?
>
>Thanks in advance !!!