SQL database
Select Case When Len (NEWS_NAME)> 10 Then Left (news_name, 10) '...' Else News_name end as news_name, news_id from news
Access database
SELECT IIF (Len (Title)> 2, Left (Title, 2) '...', title) from SiC_Article
