Regular Expressions in SSMS



In one of my posts ,
I gave a tip how to replace
Enters in MS Word. We can
do this and a lot more in
SSMS itself by using
Regular expressions.





By pressing Ctrl+H in the SSMS you will open the "Find and Replace".





















Choose in the Use option "Regular expressions".
Now, if you do not know how to use the regular expressions,
SSMS provides you a basic help, press the button with
bold arrow:





















So, for example you want to replace Enters(new line seperators)
to commas(","), then enter "\n"  in Find What text box and ","  in
Replace with text box.

You can find more isu here.