데이터베이스/SQL Server
Where 절 CASE문 사용
발가락
2008. 4. 29. 08:59
728x90
(Select PaperNum, DeptCD, EmployeeID
From DECIDE_APPR
Where EmployeeID = @pDeptCD
And ApplyCHK LIKE CASE @pStatusCHK
WHEN '0' THEN ''
ELSE RTRIM(@pStatusCHK) + '%'
END ) T2
From DECIDE_APPR
Where EmployeeID = @pDeptCD
And ApplyCHK LIKE CASE @pStatusCHK
WHEN '0' THEN ''
ELSE RTRIM(@pStatusCHK) + '%'
END ) T2
[출처] Where 절 CASE문 사용|작성자 윈마스터