How to use case statement in ms sql server?

  By Junaid A   Posted on August-01-2022   156

MS Sql Server

How to use case statement in ms sql server?

 

select         
        case 
            when Role_ID=1 then 'admin'
            when Role_ID=2 then  'other'
            when Role_ID=3 then  'Nine'
        end 
               Role_ID
        
        from RoleInterfaces

By  asifjans    01-Aug-2022 Views  156



You may also read following recent Post