Wild cards in query

[Smarty]

Hey,

I have a code stored in one field in a database. This code consists of 4 parts. Is there a possibility to use wild cards for some bits of the code?
I would like to use it in ASP with an Access database, but it doesn't work. I used %,*, and ? but none did what I want. The search engine with the generated query is on

http://www.lucronbioproducts.com/_Vl/zoekjackson.asp

It works if you fill in all the fields, but not with a wild card...

Can anyone help?

Kind regards,
(not so) Smarty

 

[dhookom]

Why would you not provide any information about your SQL syntax or statement? This is a SQL forum, show us your SQL.

I think you might have other issues with your web page. I got this error when attempting to load it:

Microsoft JET Database Engine error '80004005' 

Could not use ''; file already in use. 

/_Vl/basistop.asp, line 26

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]