Forums » Toad for SQL Server General

Thread: Format SQL with AND key word

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 1 - Pages: 1 - Last Post: Jan 3, 2012 11:37 PM by: rpouwels Threads: [ Previous | Next ]
mtechera

Posts: 1
Registered: 12/21/11
Format SQL with AND key word
Posted: Dec 22, 2011 9:27 AM
 
  Click to reply to this thread Reply

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



rpouwels


Posts: 6
Registered: 1/3/12
Re: Format SQL with AND key word
Posted: Jan 3, 2012 11:37 PM   in response to: mtechera
 
  Click to reply to this thread Reply

Hi Mario,

Which version of Toad are you using?

Regards,
Robert

When the right way doesn't work, go left.
Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums