SQl Server FREETEXTTABLE return matched text.

I have a table say tblResumes

columns

ID  Name   Position   Resume(nText)

I run a FREETEXTTABLE search.

I want to be able to retun only the Text from the column(Resume) which match the keywords in the FREETEXTTABLE search.
Something along the lines of google results.


For Example(This is a sample resume in the "Resume" Column) :

System Admin and database Administrator job involves the following: IMV Project System Implement Schedule Control and Follow up (20 of Sub Systems).    - Cooperate with outsourcing and Global Toyota company to implement system as following items:User Requirement, Infra Structure Design, Database Design, User Design, Unit Test, System Test, User Acceptance Test, System Go-live etc. Application Investigate Skill of Maintenance Phase.  System Administrator: Server Specification Design. Operating System Performance Utilization Monitoring and Analysis to scale out. Application Deployment logging version and check shet control. System Backup and restore. Disaster Recovery Plan Design and Backup Site of Server Room implementation. IIS Web Service configuration and Performance Tuning. Application Component Service configuraiton. Scheduled Task Configuration. N-Tier Application Knowledge and Implementation. SAN Storage administrator (Raid 1+0). LAN/WAN/VPN, Intenet, Intranet Configuration, Proxy/Firewall/Ftp configuration. Implement and Maintaining MS Windows Server Active Directory Infra-Structure.  Database Administrator: Setting Task of Daily, Monthly, Yearly of Database Maintenance Plan such as Automatic Full Backup, Rebuild index, Data Integrity Check:    - Microsoft SQL Server 7  Database Servers (ERP-Powercerv System).    - Microsoft SQL Server 2000 Database Servers (SCMS Phase 1 have 11 Sub System).    - Microsoft SQL Server 2000 Database Servers (SCMS Phase 2 have 5 Sub System).    - Microsoft SQL Server 2000 Database Servers (SIS).    - Microsoft SQL Server 2000 Database Servers (Tool). Microsoft SQL Server Cluster Configuration and Tuning. Database Installation, Standard Configuration and Controlling User Access Configuration. Configuration of Database Performance Tuning. Database Problem Investigate and Solving. Database Performance Utilization Monitoring and Analysis to scale out. Replication Implementation between various database.  Other  


 IF I run a search for 'Microsoft Database Administrator'

Is it possible to return only matched text chunks rather than return all the text from that column. Something like return the 5 preceeding and 5 succeeding words of the macthed keywords.


Is it possibel to do in SQl server or should this be done from the application end?
If yes then please guide me in the right direction.
LVL 8
isaackhaziAsked:
Who is Participating?
 
John ClaesSenior .Net Consultant & Technical AnalistCommented:
as Far as i know :
you can't search inside a Ntext field.

what can you do ?
1) convert to nvarchar whe searching ==> Slow because every ntext must be converted

where convert(nvarchar(4000), Resume) like '%YoursearchMatch%'

2) you can extract all the records towards the Client and do the search there because they are all strings==> very slow.

if you need more info ....
poor beggar
0
 
isaackhaziAuthor Commented:
All I need is a google style result page....

I want to be able to get chunks of text from the entire text field that contain the keywords the user searched for.......

Is anyother approach possible... ??
0
 
John ClaesSenior .Net Consultant & Technical AnalistCommented:
as far a I know, You'll have to do the most a Server-Side and not at DB side
I'm realy sorry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.