Search Memo Field

[XMan]

I have this SQL statement and it's not working for memo field DESCRIPTION:

SELECT DESCRIPTION FROM COMPLAINTS WHERE DESCRIPTION LIKE '%accident%';

Do I need to convert memo field to VARCHAR or other functions to make it
searchable? TIA.

 

[XMan]

I can't believe it...It's "*" instead of "%"

SQL2K uses "%" and Access uses "*".....

 

[Dale Fye]

In Access you need to use the asterisk instead of the percent.

SELECT Description
FROM Complaints
WHERE Description Like "*accident*"

--
HTH

Dale Fye


I have this SQL statement and it's not working for memo field
DESCRIPTION:

SELECT DESCRIPTION FROM COMPLAINTS WHERE DESCRIPTION LIKE
'%accident%';

Do I need to convert memo field to VARCHAR or other functions to make
it
searchable? TIA.