Evan,

This is a must have link/tool:

http://www.sqlinform.com/sqlformatter_v2.phtml

It is great, and you can get a license for local use.

-R!


>In SQL 20005 Mangement Studio, I can right click on a database and create a new query. I assume this is the query analyzer. Sometimes when debugging, I paste in a SQL statement string from my FoxPro or .NET code. It all gets put onto 1 line and I have to use the tab and enter keys for format the statement onto several lines so that I can work with it better. Also having the SQL statement on more than 1 line helps to narrow down syntax erros. Anyhow...
>
>Is there a way to automatically format a SQL statement into a multiple lines. With the Selec one 1 line, then where on the next etc...