Dear Readers,
I have a query that I input values to and return results. In my query criteria I have Like "*" & [@input] & "*" . When I run the query in Access everything works fine. It returns results for everything that matches "chr" which includes "chris","Christine","christ", etc.... When I run the stored procedure in asp.net it returns no results and no errors? Any suggestions????

try
objcmd.connection.open()
objreader = objcmd.executereader

while objreader.read

response.write("<BR>Id=" & objreader("custid"))

end while

catch ex as OleDbException

response.write(ex.tostring)

end try

Try using % rather than *. OleDb uses the standard wildcard characters, % for one or more of any character, and _ for one of any single character.

Dear Douglas/Readers,
Thanks, that worked! It sorta funny that when I used the query in access it returns no fields for a search. But the same search via asp.net returns values perfectly. Thank you very much for your help.


Query Criteria Looks Like:

like "%" & [@input] & "%"

Hi ! This query using Like Keyword in msaccess 2007 is working .

select * from tablename where po like '*'+'value'+'*'