can anyone help me with putting a case in the where clause? i've wrote understanding case. But i get an error and don't know what is wrong. "Dossier.laaddatum" = a field from the database i want the compare.
case when datepart (dw,getdate()) = 5 then dossier.laaddatum <=getdate() +3 else when datepart (dw,getdate()) = 6 then dossier.laaddatum <=getdate() +2 else dossier.laaddatum <= getdate()+1 end
WHERE dossier.laaddatum <= CASE WHEN datepart (dw,getdate()) = 5 THEN getdate() +3 WHEN datepart (dw,getdate()) = 6 THEN getdate() +2 ELSE getdate()+1 END
Jim
Everyday I learn something that somebody else already knew
case in where clause
Posted - 11/26/2012 : 13:42:51
