strNewsLtrs: SELECT *, DATENAME(MM, ArticleDate) + ' ' + CAST(YEAR(ArticleDate) AS VARCHAR(4)) AS ArchiveGroup FROM NewsArticles WHERE (DATENAME(MM, ArticleDate) + ' ' + CAST(YEAR(ArticleDate) AS VARCHAR(4)) = 'January 2007') AND (SiteID = 83) AND (NewsArticles.Show = 1) AND (ArticleType='normal') ORDER BY ArticleDate DESC;

About Us Contact Us Property Search Foreclosure Search Featured Properties Buyers Sellers Loan Info

Archive January 2007

jump:   

 


No Articles to Display