I need to replace a word in a Document through SQL Server 2008

15 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Shayguri
    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
    15 pointsBadges:
    report
  • Shayguri
    [...] 10. Mrdenny gave a member suggestions on editing a document in SQL Server 2008. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following