use cms
select newsid from news
select top 4left(newstitle,4) from news
string strSqlnow = "select top 4left(newstitle,20) newstitle,newsid from news order by newstime";
use cms
select newsid from news
select top 4left(newstitle,4) from news
string strSqlnow = "select top 4left(newstitle,20) newstitle,newsid from news order by newstime";