Select NewsTitle,Concat('/news/',NewsLink,'-',Cast(NewsID as char),'.html') as NewsLink,NewsDate,NewsContent, Case NewsIcon when '' then '/frontpages/images/news.png' else NewsIcon end as NewsIcon from rd_news_data where Active = '1' Order By NewsDate desc;