sql server - How to show specific condition in column?

Question

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.

Answer 1

Declare @Param Varchar(MAX) = 'Ciaz'
SELECT FirstName, LastName, @Param AS ConditionalColumn FROM Employee
WHERE LastName != @Param

Line 1: Declare a Varchar (string) variable @Param and assign value of 'Ciaz'. Line 2: In Select query with FirstName, LastName add @Param with 'As' keywords and column name 'ConditionalColumn', with this @Param shown as a column in your query.