Search Memo Field

  • Thread starter Thread starter XMan
  • Start date Start date
X

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.
 
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.
 
Back
Top