SQL queries strings of the specified length in a column are expressed by ellipsis.

The Gridview control is often used. However, in some cases, too much content is displayed, which may easily cause page deformation. It is too ugly. Therefore, sometimes we only need to display the first few strings for the sake of appearance, the rest can be expressed by ellipsis. The following is a piece of SQL code for intercepting strings. If you need it, you can take it away. Thank you.

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

Example: substring (M_download,) as M_download from Movie