I have this very weird need, I have a query that contains some conditions. Here is a sample one.
SELECT FirstName, LastName, ConditionalColumn FROM Employee
WHERE LastName != 'Ciaz'
I want to show the WHERE
conditional column value in ConditionalColumn
.
So that column will have Ciaz
in it.