Schleid Alex

Schleid Alex

  • NA
  • 361
  • 47.7k

Select case with another select after then

Apr 7 2021 1:12 PM
Hi,
 
I am looking to have a transact sql statement going like this
 
I am trying to concatenate firstname and lastname from the table employee whenever isEmployee = 1
 
 
Thanks for helping
  1. when 1 then  
  2. (  
  3.  select firstname + ' '+ lastname   
  4. )  
  5. from tblEmployee  
 

Answers (6)