Use of wildcard with a variable input

[sbedford]

Hi

I am trying to implement an sql query through delphi, using microsoft access sql code. I am having trouble getting it to do what I want.

I want to be able to type in a description of an item, where if any part of that item description is found in the other descriptions in a table, it will display the results. I am using the variable [desc] so that access asks for me to enter what goes here upon running the query. I cant add the asterisks though, as access puts the thing between quotes like "*[desc]*".I have also tried putting the asterisks in the [desc] variable like "*test*", but delphi appears not to accept an input like this. Is there any way I can do this?

Thanks

Sean Bedford

 

[DotNetGnat]

you need to use % instead of *

-DNG

 

[sbedford]

thanks - weird how access uses * and everything else uses % :\

 

[DotNetGnat]

yeah it is weird...anyways glad to know its working for you.

-DNG