need to captialise characters of a string in visual studio text editor

Question

Is there a way I can automatically change a string to the upper version.

For example:

select * from table

would be:

SELECT * FROM table

After selecting both select and table and applying such a function. Typically I create the sql in a web editor, then copy paste it into my code, but have to format it a bit.

Answer 1

I use general settings : Control Shift U ? It's under Edit | Advanced

Answer 2

You might also want to into the "SQL Refactor" product offered by Red-Gate. The product will automatically layout and format your SQL queries.