Home > IT Answers > SQL Server > I need to replace a word in a Document through SQL Server 2008
Shayguri
15 pts.
 I need to replace a word in a Document through SQL Server 2008
SQL 2008, SQL Server, SQL Server 2008, SQL Server 2008 R2
Hello 
i'm using SQL 08 R2 to store my resume collection , i want Sql to find an Email  in the MS WORD document and replace it with an empty string 
so far I've succeeded to find the word using fullTextSearch 
this my example for finding the documents that contain an email 
SELECT  document
FROM Resume
WHERE contains(document,'"%@%.com"');
i want to replace this email with an empty string ' meaning i want to delete it from the document
does anyone have an answer for me ?


Software/Hardware used:
SQL SERVER 2008 R2, MS OFFICE
ASKED: January 4, 2011  3:52 PM
UPDATED: January 4, 2011  8:26 PM
RELATED QUESTIONS
Answer Wiki:
You can't use T/SQL to edit a word doc which is stored within a database table. You would need to save the document to disk as a document then edit it. Why are you storing your resumes in SQL Server anyway?
Last Wiki Answer Submitted:  January 4, 2011  7:47 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

i’m building a Job Portal Project
so , if i can’t change it within SQL can I open in virtual and edit it by using sql

i need to do this automatic

Shayguri
 15 pts.