In this example, Quantrimang used the second and fourth parameters in the CONCAT function to add a space character between values Orange, Peach and Apple. This will help the strings not be tied together.
Previous article: CHARINDEX function in SQL Server
the article will explore and show you how to use the datalength function in sql server to display the number of bytes used to represent an expression ..
the len function in sql server returns the length of the specified string. it is important that the len function does not include whitespace characters at the end of the string when calculating length.