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.

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...;)