SQL query against a Memo field

[Bragi Fannar]

I'm trying to run a query where a memo field is LIKE something. the query
is supposed to find a textstring somewhere in the field, here's the query:

rs.Open "SELECT * FROM tblTable WHERE MemoField LIKE '%" & Text1.Text & "%'",
CONN

Ive tried using both % and *

The query always returns end of file.

[tika]

Your select statement is incorrect.
I would advise you to test your SQL statements before putting them into your
ASP code.
ie. put them in Query Analyzer first

"Bragi Fannar" <bragi@islenskmidlun.is> wrote:
>
>I'm trying to run a query where a memo field is LIKE something. the query
>is supposed to find a textstring somewhere in the field, here's the query:
>
>rs.Open "SELECT * FROM tblTable WHERE MemoField LIKE '%" & Text1.Text &
"%'",
>CONN
>
>Ive tried using both % and *
>
>The query always returns end of file.
>
>