Like statement help 2

[Stewman]

Hello,

I have an access database that contains a table called customers and a column called title. What I want to do is query this table and return records that contains sales in the title name but that doesn't start with sales. For example it would return district sales manager but not sales manager. I've been trying numerous like statements but none works form. Any help greatly appreciated.

 

[SkipVought]

Hi,

Where Mid([Title],2) Like '*sales*'

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Stewman]

Thanks SkipVought, that worked perfectly.