Toad World® Forums

Cannot properly align columns in a select statement

TOAD 10.6.1.3

I am trying to use the formatter to align a select statement like this:

SELECT surname,
first_name,
middle_name
FROM employee
WHERE surname = ‘SMITH’;

I am using the formatting options, and while I can get it to look like this in the “My Example Code” window, when I try it in the actual SQL editor window, it looks like this, after formatting:

SELECT surname,
first_name,
middle_name
FROM employee
WHERE surname = ‘SMITH’;

Older versions on TOAD would format this the way that I was wanting.

Does anyone have any tips to format this select like the top example? Thanks a lot.

This is not looking proper after it is posted.

What I am looking for is for the T in the SELECT, the M in the FROM, and the E in the WHERE to all right-align. I then want the columns and the table to left alight, after one blank space.

SELECT surname,
first_name,
middle_name
FROM employee
WHERE surname = ‘SMITH’;