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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 search

Author  Topic 

ramesh.g
Starting Member

11 Posts

Posted - 2010-10-06 : 07:24:02
hello all of u ..
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 mca

The table tblVacancies have following field :

[VacancyId]
,[RecruiterID]
,[Criteria]
,[Industry]
,[Country]
,[CompanyName]
,[JobDescription]
,[Positions]
,[Background]
,[Skills]
,[Eligibility]
,[Experience]
,[Email]
,[PhoneNo]
,[vdate]
,[KeyWords]

please help.

Sachin.Nand

2937 Posts

Posted - 2010-10-06 : 08:55:46
Show us what have to tried so far?

PBUH

Go to Top of Page

kunal.mehta
Yak Posting Veteran

83 Posts

Posted - 2010-10-11 : 02:20:34
can't u put individual textboxes for each search criteria?
Go to Top of Page
   

- Advertisement -