sql case when

SELECT *,
        processString=
        CASE
               WHEN process=0
               THEN 'a'
               WHEN process=1
               THEN 'b'
               WHEN process=2
               THEN 'c'
        END
 FROM   bulkYarnSendingSchedule
        LEFT JOIN
               (SELECT NAME,
                       CLIENT_ID
               FROM    client
               ) c
 ON     bulkYarnSendingSchedule.clientId=c.client_Id
 WHERE  orderNo BETWEEN 'CL120001' AND 'CL130004'
 

SELECT *,
        CASE process
               WHEN 0
               THEN 'a'
               WHEN 1
               THEN 'b'
               WHEN 2
               THEN 'c'
        END AS processString
 FROM   bulkYarnSendingSchedule
        LEFT JOIN
               (SELECT NAME,
                       CLIENT_ID
               FROM    client
               ) c
 ON     bulkYarnSendingSchedule.clientId=c.client_Id
 WHERE  orderNo BETWEEN 'CL120001' AND 'CL130004'