Case when statement in where clause

[Mani Raja]

When I execute the below query im getting the following error
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near ')'.
Any one please give a solution to solve this.

In the below query dbo.FNSplitString is a user defined funcion to split the values in the string, since here project code parameter is in varchar but in the table it is integer datatype.

DECLARE @prjcode VARCHAR(1000)
SET @prjcode='0'
--SET @prjcode='80,83,323'
SELECT * 
  FROM prolive.eld_pliv_emp_log epel
WHERE epel.eld_shift_date BETWEEN '01-Jan-2012' AND '13-Jan-2012'
AND epel.eld_prj_code IN (CASE WHEN @prjcode ='0' THEN epel.eld_prj_code ELSE (SELECT DATA FROM dbo.FNSplitString(@prjcode,',') ) )

[Rabbit]

You forgot the END statement of the CASE.
[code]

DECLARE @prjcode VARCHAR(1000)
SET @prjcode='0'
--SET @prjcode='80,83,323'
SELECT * 
  FROM prolive.eld_pliv_emp_log epel
WHERE epel.eld_shift_date BETWEEN '01-Jan-2012' AND '13-Jan-2012'
AND epel.eld_prj_code IN (CASE WHEN @prjcode ='0' THEN epel.eld_prj_code ELSE (SELECT DATA FROM dbo.FNSplitString(@prjcode,',') ) END)