sql statement formatter

From: steve <a_at_b.com>
Date: Thu, 18 Dec 2003 09:38:47 -0600
Message-ID: <vu3ik24snpg915_at_corp.supernews.com>

[Quoted] [Quoted] does anyone know of a tool, or better yet, source code that can format sql statements.

we've all had those one line sql statments that are a mile long. i'd like to use something that cures that and puts them into something like:

SELECT     col             MyCol,
                   co2           YourCol,
                   col3           RollCol
FROM       tab1
WHERE    col1            = 'yo momma'
AND         col2            = 'sup?'

you know, nicely and aligned...more legible...etc.

tia,

steve Received on Thu Dec 18 2003 - 16:38:47 CET