SQL数据库
select case when len(news_name)>10 then left(news_name,10)+'...' else news_name end as news_name,news_id from news
Access 数据库
SELECT iif(len(title)>2,left(title,2)+'...',title) FROM Sic_Article;
SQL数据库
select case when len(news_name)>10 then left(news_name,10)+'...' else news_name end as news_name,news_id from news
Access 数据库
SELECT iif(len(title)>2,left(title,2)+'...',title) FROM Sic_Article;