The specified field in SQL Server displays a fixed length

The specified field in SQL Server displays a fixed length, which is often used when displaying data, but has a bad memory and often forgets.

So write this so that when it is useful, pick it up.

For example, there is a article table with 3 fields in it.

Show the time for some reason, the title, content can not be shown too long, here can not set more than 11, the rest with "..." instead of content text can not be more than 30, otherwise use "..." instead:

Select articletitle=

case when Len (articletitle) >11

Then substring (articletitle,0,11) + ' ... '

else ArticleTitle

End

, articletime,articlecontent=

case when Len (articlecontent) >11

Then substring (articlecontent,0,30) + ' ... '

else articlecontent

End

From Article to Articletime desc