Ability to wrap code before / after arithmetic operations in SELECT list
3
votes
![](https://secure.gravatar.com/avatar/ebf67e4a99ded189c9425f709b9b138b?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Anonymous commented
I've been looking at some old legacy code at work where they seem to like build up an email to send out using strings with + in them. for readability it would be great to format the code on the + and put the + on a new line.
-
Anonymous commented
That I need !!
e.g.select
1 as name
,N'test test test test test test '
+ cast('111' as nvarchar(10))
+ N'test test test test test test test test'
+ case
when 1 = 0
then 'Test'
else N'No test'
end
as [Alias]
from
[dbo].[Table1] [t]Thanks...;)