Query how superfluous strings of a column of specified length are represented by ellipses

Query a column of the specified length of the string how to use ellipsis to express, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

We often use the Gridview control, but sometimes, the content displayed is too much, which can easily lead to page distortion and ugliness. Sometimes, in order to be beautiful, we only need to display the first few strings, and the rest can be represented by ellipses.

The following is pasted with a sql intercept string code

Select substring (column name, start, end) as column name from table

For example: substring (masked download.0pl 20) as M_download from Movie

After reading the above, have you mastered the method of querying how to express the excess of a string of specified length with an ellipsis? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!