Where clause CASE statement

I was given pseudo code for a check to see if a date is between a stat date and end date and using a CASE statement change the end date to 99999999 if it is 0. I need to check if the date is in a 3 year range. I am not an expert on CASE statements and never used one in a Where clause before. This is enrollment info. Here is the code and I hope someone can help me out.

WHERE EligibilityHistory.CoverageGroupCode = '010218'

AND 20100601 between EligibilityHistory.EligibilityStartDateAND EligibilityHistory.EligibilityEndDate
Case When End = 0 then 99999999 Else End

Thanks to anyone that can help. I am not sure if this is the way to go, but I have to try.

arep

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Try this:

WHERE EligibilityHistory.CoverageGroupCode = '010218'
AND (20100601 BETWEEN EligibilityHistory.EligibilityStartDate AND
CASE
WHEN EligibilityHistory.EligibilityEndDate = 0 THEN 99999999
ELSE EligibilityHistory.EligibilityEndDate
END)
0