SQL Prompt allows you to uppercase selected keywords in a script. For example, the following line of SQL:

select * from Person.Contact as c

can easily be modified to:

SELECT * FROM Person.Contact AS c

To uppercase keywords:

1. Open the script you want to modify in a SQL Server Management Studio query window.
2. If required, select a portion of SQL in the script that contains the keywords that you want to uppercase.
   If you do not select any SQL, all keywords in the script are uppercased.
3. On the SQL Prompt menu, click Uppercase Keywords.

You can undo the changes to the script using the standard SQL Server Management Studio Undo features.

To keep the changes, save the script.