AFAIK there is several beautifiers out there, but freeware? You may want to search the web for "SQL beautifier" to see if there is anything for you. -- Frank Kalis Moderator Microsoft SQL Server MVP Webmaster:http://www.insidesql.de
I know its now freeware, but SQL Refractor from www.red-gate.com does this, plus a lot more. -------------------------------- Brad M. McGehee, SQL Server MVP http://www.sqlbrad.com
I found an online formatting site wich doesn't require java http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl They also have a plugin for SSMS but not for free. Thanks,EB
SQL Prompt and SQL Refactor of red-gate are great tools. But it will cost you ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
