[SQL] CASE WHEN のサンプル

SELECT *, CASE WHEN T_Bar.CompanySectionID = '1' AND 
       sSalesCompanyID = '' THEN 0 ELSE 1 END AS CaseP1, 
       T_CompanySection.CompanySectionName + ' ' + T_Bar.sSalesCompanyName
       + ' ' + RTRIM(T_Bar.sDepartment) 
       + ' ' + RTRIM(T_Bar.sName) 
       + ' ' + RTRIM(T_Bar.sAddress) AS Info
FROM T_Bar INNER JOIN
    T_CompanySection ON 
    T_Bar.CompanySectionID = T_CompanySection.CompanySectionID
ORDER BY CaseP1, T_Bar.CompanySectionID, T_Bar.sSalesCompanyID