>>select case when DAY(EventTime)%2 =0 then 1 else 0 end as Even from CommunicationLog
>
>Interesting, I tried using DAY() and it returned an error that it couldn't be used....which is why I posted.
Strange, worked for me in SQL 2008
select * from CommunicationLog where DAY(EventTime)%2 =0
where did you try this type of query?
If it's not broken, fix it until it is.
My Blog