Toad World® Forums

Format SQL with AND key word

I would like to configure the “Format SQL” so that when using the word AND in SELECTs etc,
that the AND word should appear at the beginning of the line and aligned. Something like this:

select
col1
from
table1
where
col2 = x
and col3 = y
and col4 = z;

Any ideas on how to do this?

Regards,
Mario

Hi Mario,

Which version of Toad are you using?

Regards,
Robert