Case statement in select clause - using table view
Select
c.FirstName
,ln = c.LastName
,e.JobTitle
,d =
Case
When a.AddressLine1 = 1 Then 1
End
,a.City As ct
,a.PostalCode
6
votes

-
Joel Brown commented
A case statement in the select clause is not aligned to the second column when using table view option.