Query works in Access but not with exec call from .net

[Electric Bliss]

Greetings all...

This has been driving me nutz and I was hoping an expert could help shed
some light.

Why does this query work in Access but not in an
OleDbCommand.ExecuteReader() call?

SELECT tblFilterPhrases_Subject.strPhrase
FROM tblFilterPhrases_Subject
WHERE ((('VIAGRA') Like '*' & [strPhrase] & '*'));
Here is the C# code I'm using:

OleDbCommand sqlCommand;
sqlCommand = new System.Data.OleDb.OleDbCommand();

try
{
sqlCommand.Connection = conn;
sqlCommand.CommandText = "exec Query1";
dreader = sqlCommand.ExecuteReader();
}

The reader comes back as not null... but it contains zero records. In Access
I run the query and it comes back with the correct record. What am I missing
here?

EB

[pietlinden]

try using % as your wildcard character. ADO uses a different one than
Access.

[Electric Bliss]

<pi********@hotmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

try using % as your wildcard character. ADO uses a different one than
Access.

Thanks Pietlinden. I found what the problem is but I don't know how to fix
it. Here is my sql statement again:

SELECT tblFilter_Subject.strPhrase
FROM tblFilter_Subject
WHERE ((('VALíUMM') Like '%' & [strPhrase] & '%'));
Some of the data in strPhrase has open square brackets in it! Took me for
bleedin' ever to find that... so the next question is... how to escape an
open bracket in the situation above??

EB