Query not working with Data Access page

[R. Weston]

i have the following query:

PARAMETERS [SpecToSearchBy] Text ( 255 );
SELECT *
FROM sec1
WHERE (((sec1.spec) Like "*" & [SpecToSearchBy] & "*"));

which works fine when i try it in access. The parameter
is requested and i enter something like "prf" and it
returns all the data. Now when i try it through the data
access page, it gets no results.

I tried:

PARAMETERS [numbertofind] Long;
SELECT *
FROM test
WHERE [test].[test] = [numbertofind];

with some numerical data through the data access page and
that worked.

Is there something that has to be done different with
using LIKE and text?

 

[Dan Artuso]

Hi,
Have you tried it with the % character as the wildcard?