Select records using like statement

[Hamayun Khan]

Hi all

I am using the following query to select records for table

Select JobTitle,JobDesc,Scraped,logoimage,JobPostID,Schoo lID,web,MemType,InstitutionName,PayScale,LEA,Contr act as ContractType,HoursAbl,StartDate,ClosingDate,asap from tblJobScrap Where ((JobTitle like '% Art %' OR JobTitle like '% Art and Design %' OR JobTitle like '% Art & Design %'))

This query return the records having no keywords like Art ,Art and Design or Art & Design but having words having Start (for St(Art) ,P(art) etc) where I want to retrieve only those records that have Art word.
I don't know how i can do this
Any Help in this issue

[cokelite]

Seems to me you don't have spaces around the word Art in your actual query. So use '% Art %' instead of '%Art%'.

I would do it like this:

WHERE JobTitle like '% Art %' OR JobTitle like 'Art %' OR JobTitle like '% Art'

[Hamayun Khan]

@cokelite
Thanks for giving a useful Hint. Really work for me