Tony Rogerson's ramblings on SQL Server

	Tony Rogerson is an independent SQL Server specialist based in the UK, this is his blog fed from his day to day experience as a consultant and work in the SQL community.
	follow me on Twitter

11 January 2010 08:20 tonyrogerson

Removing blank line in SSMS (Management Studio) Find and Replace dialogue

Yes, copying between word and email always puts an extra line between code lines which makes the code hard to read.

The answer is simple; in Management Studio go into Find and Replace, in "Find Options" check "Use" and select "Regular Expressions".

Now, in the Find what: box enter the text ^\n

In the Replace with: box enter nothing, please don't take me literally on that and actually type the word nothing, I mean leave the text box empty.