In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However, I didn’t show how to actually change the text.

Just select the text, and use the keyboard shortcuts Ctrl+Shift+U or Ctrl+Shift+L to change the text to upper case or lower case respectfully. Like most things in SSMS, these can be selected from a menu also. In this case, they hang off of the Advanced submenu from the Edit menu:

As you can see, it’s just a simple key press to quickly change the case of your text. It’s unfortunate that SSMS doesn’t support other options, such as Camel Case.

This post is for day twelve of my month-long blog series “A Month of SSMS Tips”. I have a landing page for the series at bit.ly/MonthOfSSMS. Please visit this page for an easy place to quickly view all of the other tips in this series.