>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 !!!
Hi,
Try this
"Select * from livros where autor like ""*" & request.Form("texto") & "*"""
Access uses double quotes instead of single quotes. Also, the positioning of the wildcard character should be ok at the end. Another suggestion is to change both sides of the comparison to upper case (just another precaution).
Ricardo A. Parodi
eSolar, Inc.