Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramesh.g
Starting Member
11 Posts |
 Posted - 2010-10-06 : 05:28:53
|
| I have to search like input in textbox - software developer,india,3 years,mca then it should display all the record who is software developer and he/she belong to india and have expreince 3 years and degree mcaThe table tblVacancies have following field : [VacancyId] ,[RecruiterID] ,[Criteria] ,[Industry] ,[Country] ,[Country2] ,[Country3] ,[Country4] ,[Country5] ,[City] ,[City2] ,[City3] ,[City4] ,[City5] ,[CompanyName] ,[JobDescription] ,[Positions] ,[Background] ,[Skills] ,[Eligibility] ,[Experience] ,[Email] ,[PhoneNo] ,[vdate] ,[KeyWords]please help. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-10-06 : 08:42:02
|
| no need to post twice. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151147select * from tblVacancieswhere jobdescription = x and country = y and experience = zsplit the input box into seperate fields outside of SQL...freeform input => bad ideabetter still have multiple search boxes. |
 |
|
|
|
|
|
|
|
advanced search