Anding in query

[yogi2002]

Hi I am deveoping a web site for subimmiting resumes. I am storing user skillsets in one field in access database. in page for view resumes by skills i want to give facility for ANDing in skillsets. At the moment the query which i am using lets me to search for single skillset. I am using syntax in sql query as

Select * from resumes Where ResSkills like '%sql%'


now if i want to search multiple skills in same fields how should be syntax of my sql query


Yogesh

 

[JerryDennison]

You should consider splitting the skill sets off into it own table linked back to the submitter. This will make searching MUCH easier. Not to mention helping you achieve at least the First Normal Form.

 

[smedvid]

Sorry, not much u can do that I can see other than....

Select * from resumes Where ResSkills like '%sql%' OR ResSkills like '%sql%' OR ...

Also.. U may want to perform an Upper Case function on ResSkills and use upper case in the search criteria (ie. sql) to insure proper coverage. Unless you are 100% sure on the way information is entered.

htwh Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[smedvid]

I am pretty sure the "%" should be an "*"...

SELECT Table1.*
FROM Table1
WHERE (((Table1.Field2) Like "*sql*&quot) OR (((Table1.Field2) Like "*oracle*&quot); Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/