Alias Formatting Oddity
![Ronkochanowski](https://us.v-cdn.net/6029854/uploads/defaultavatar/nZUSABQN8JEE0.jpg)
in SQL Prompt
There appears to be an issue with aliases aligning with statements followed by a tab, and I can't figure out where the setting is that adjusts this. See the below images to understand:
![Image: https://us.v-cdn.net/6029854/uploads/editor/to/lgbsf9eisaym.png](https://us.v-cdn.net/6029854/uploads/editor/to/lgbsf9eisaym.png)
![Image: https://us.v-cdn.net/6029854/uploads/editor/4l/aq3tftwu15dr.png](https://us.v-cdn.net/6029854/uploads/editor/4l/aq3tftwu15dr.png)
I'm seeing this in the first line after a SELECT statement, that a tab is added, as well. Subsequent lines are formatted correctly. SET items are aligned with the Statement and the first line has a tab inserted, while SELECT items are aligned properly, yet still have a tab added after the first alias name:
![](https://us.v-cdn.net/6029854/uploads/editor/ad/7g564pvmgz73.png)
![Image: https://us.v-cdn.net/6029854/uploads/editor/to/lgbsf9eisaym.png](https://us.v-cdn.net/6029854/uploads/editor/to/lgbsf9eisaym.png)
![Image: https://us.v-cdn.net/6029854/uploads/editor/4l/aq3tftwu15dr.png](https://us.v-cdn.net/6029854/uploads/editor/4l/aq3tftwu15dr.png)
I'm seeing this in the first line after a SELECT statement, that a tab is added, as well. Subsequent lines are formatted correctly. SET items are aligned with the Statement and the first line has a tab inserted, while SELECT items are aligned properly, yet still have a tab added after the first alias name:
![](https://us.v-cdn.net/6029854/uploads/editor/ad/7g564pvmgz73.png)
Tagged:
Best Answer
-
Ronkochanowski Posts: 4 New member
Hmmm...tried one last thing after posting the above...
Under Whitespace, changed Spaces or Tabs to "Tabs where possible", instead of "Only tabs" and the alignment adjusted as I desire it to be.
I must not understand the difference between the two terms.