Full Text Search Help. - SQL Server Forums

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 2000 Forums

Transact-SQL (2000)

Full Text Search Help.

Author

Topic

fahad_001
Starting Member

11 Posts

Posted - 2008-04-04 : 07:44:19

Dear All

I want to search applicants who have done PHD. SO i write a query

Select j.Job_Title_Str,JA.JApl_ID_Num,JA.JApl_Fname_Str,JA.JApl_LName_Str
from Jobs as j, JobApplicants as JA, ApplicantEducation as JE
where j.Job_ID_Num=JA.Job_ID_Num
and JA.JApl_ID_Num=JE.JApl_ID_Num
and JE.APEdu_Degree_Str like '%phd%'

it work very fine. But i want to use Full Text Search instead of like.
Can any one guide me what syntax i have to write to convert this query into full text search query.
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-04 : 14:00:47

refer this:-

http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-04 : 23:37:46

You have to create full text index first before querying with it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources