how to implement Progressive (continuous) dots for article using SQL?

We are going to learn how to implement Progressive (continuous) for an article using SQL server using SUBSTRING.

SELECT SUBSTRING(title, 1, 50)+'.....' AS Title FROM Post;

 

OUTPUT:

How to use CAST function in SQL......