if condition use with case when then in sql server code example
Example: end as sql
select
case when ID in ('1', '2', '3')
then 'Jack'
else 'Jim'
end as Person
from Table.Names
select
case when ID in ('1', '2', '3')
then 'Jack'
else 'Jim'
end Person
from Table.Names