← Customer Feedback for Devart Settings and activity 1 result found Ability to wrap code before / after arithmetic operations in SELECT list 3 votes Vote Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close 1 vote 2 votes 3 votes Remove votes You have left! (?) (thinking…) 2 comments · SQL Complete · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close Anonymous supported this idea · Oct 10, 2014 An error occurred while saving the comment Anonymous commented · Oct 10, 2014 · Edit… · Delete… 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...;) Save Submitting...
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...;)