467,910 Members | 1,783 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,910 developers. It's quick & easy.

Select records using like statement

100+
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
Nov 20 '08 #1
  • viewed: 1727
Share:
2 Replies
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'
Nov 21 '08 #2
100+
@cokelite
Thanks for giving a useful Hint. Really work for me
Nov 24 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Jean-Claude | last post: by
4 posts views Thread by The.Daryl.Lu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.