Solved

replacing ‘ (single character in MS Word) with ' (single character in SSMS)

Posted on 2015-02-18
3
62 Views
Last Modified: 2015-02-21
I have a document in word with many ‘ (single characters in MS Word)

The Find/Replace of MS Word is not able to replace them to ' (single characters acceptable in SSMS, these are ' recognized in SQL code, they are short straight lines and do not have bend at the end. This character exist in word because when I copy one from SSMS and paste it one in Word one at a time it works fine but that is too tedious).

Question: How can I replace ‘ (single characters in MS Word) them to ' (single characters acceptable in SSMS)?

If I copy and past doc file elsewhere to find and replace, if will loose many Word specific formatting.
0
Comment
Question by:Mike Eghtebas
3 Comments
 
LVL 13

Expert Comment

by:Mark Bullock
Comment Utility
In Word settings you can turn off smart quotes.
0
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
Comment Utility
e.g.
2007: Click the Microsoft Office Button, and then click Word Options.
OR
2010: Click File, then click Options

Click Proofing, and then click AutoCorrect Options, then:

Click the AutoFormat As You Type tab, under Replace as you type, clear the "Straight quotes" with “smart quotes” check box.

Click the AutoFormat tab, under Replace, clear the "Straight quotes" with “smart quotes” check box.

derived from: Change curly quotes to straight quotes and vice versa
0
 
LVL 33

Author Closing Comment

by:Mike Eghtebas
Comment Utility
Thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
ms sql stored procedure 22 75
sql server query? 6 26
sql calculate averages 18 24
In MS Word, rename styles in a batch 9 18
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now