Query problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Returning too many records 4
Enterprise Library Data Block : GenericDatabase class and Access databases : Using ExecuteNonQuery p 0
Difficult Query 4
Query Parameter using multiple options 0
Make table query only runs from design view. 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
regular expression with linq to get files from a dir 12
Query problems with Count(IIF( ...&....)) 2

Back
Top