Categories:
Cloud (204)
Entertainment (11)
Facebook (43)
General (50)
Life (31)
Programming (64)
Technology (490)
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, ∼2862🔥, 0💬
Popular Posts:
How to download publication files from libgen.rs? libgen.rs or gen.lib.rus.ec is the most robust Web...
How headers and footers are repeated in Microsoft Word? Why I see some headers and footers are repea...
What are control codes used in Microsoft Word that can be used in the Find and Replace command? Here...
How to save word documents into Unicode UTF-8 text files? When I convert Word documents into text fi...
Where to find answers to frequently asked questions about Fitbit devices? I want to understand more ...