Wildcard in Access DB
Can somebody tell me what's wrong with my query?
WHERE main_table.FirstName= "%ann%";
I have the following firstnames: Jacqui-ann, Anna, Anne, James, and Sarah.
I'm supposed to get back the first three names, correct? I'm doing this in MS Access and my results are zero. I don't see anything wrong with my query and I've used the design view and the help guides, but still no results. Is it different in Access or something? I'm not getting errors though. Thanks.