Query problem

[rico]

Could someone tell me whats wrong with this query, it doesn't return any
results when i put the LIKE operator in. Have checked and double checked the
help files, and i'm sure the like bit is right.

SELECT FileList.Fileid, FileList.Filename, FileList.FileDescription,
FileList.FileType, FileList.RelatedToProduct FROM FileList WHERE Filename
LIKE '%D%';

TIA

Rico

 

[Allen Browne]

Try * as the wildcard instead of %.