SQL Server Strings Archives

October 26, 2020

How to remove SQL Server line break from text?

June 13, 2017

How to remove SQL Server line break from text? If you store a string as a variable or a column in SQL Server , then it can contain line breaks. For example if you export the string to excel, your line will be cut. Indeed, with SSMS, if you select …

How to split a delimited text in SQL Server?

May 31, 2017

How to split a delimited text in SQL Server? The string to split can have a comma or a semicolon delimiter. Using an SQL Server query, you can cut a string compounded of text, delimited by commas, semicolons, tabulations, dash, underscore, or even dots. It can basically be any character …