Categories:
Cloud (204)
Entertainment (11)
Facebook (43)
General (50)
Life (31)
Programming (64)
Technology (398)
Testing (4)
Tools (488)
Twitter (5)
Wearable (26)
Web Design (44)
Collections:
Other Resources:
SQL Server Truncating Message with '...'
What is the best way in SQL Server to truncate a string to 140 characters and add "..." to the end if there are more than 140 characters in the string? I need this to display initial parts of user comments on my home page.
✍: FYIcenter
Basically, you are asking the logic to be implemented in a SQL Server query,
If the string has more than 140 characters, Return the first 140 characters with "..." added to the end Else Return the string as is
A straightforward solution is the following:
SELECT CASE WHEN LEN(input)>140 THEN SUBSTRING(input,1,140)+'...' ELSE input END;
But the following solution should have a better performance:
SELECT SUBSTRING(input,1,140) + REPLACE(REPLACE(CAST( PATINDEX('%_%',SUBSTRING(input,140,999999)) AS NVARCHAR(MAX)),'0',''),'1','...');
Of course, when SQL Server supports Regular Expression, we will have a much better solution.
2015-09-16, 1710🔥, 0💬
Popular Posts:
How to create a new PowerPoint presentation from a PowerPoint template? I have a PowerPoint template...
How do I tell what version of PowerPoint my computer is using? You can determine the version number ...
"Muss i denn" is a German folk song in the Swabian German dialect. The present form dates back to 18...
Is Tahoma font supported on iPhone, iPad and other Apple devices? The answer is no. Tahoma font is n...
How to create a new WeChat account without phone number? I want to use WeChat, but I don't have a ce...