select Title, articleid, Cal_Image, Cal_Date_Start ,Cal_Date_End from tblArticles where
status = 1
and
((('#StartDate#' between Cal_Date_Start and Cal_Date_End)
or ('#EndDate#' between Cal_Date_Start and Cal_Date_End))
or
((Cal_Date_Start between '#StartDate#' and '#EndDate#')
or (Cal_Date_End between '#StartDate#' and '#EndDate#')))
and isdate(Cal_Date_End)!=0 and isdate(Cal_Date_Start)!= 0
order by Cal_Date_Start