TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
A Repasky
NA
231
183.2k
Where clause CASE statement
Jun 27 2013 4:53 PM
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
.
EligibilityStartDate
AND
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
Reply
Answers (
1
)
Cant login to SQL express?
sql server give this problem ?