In this example, we have used the second parameter within the CONCAT function to add a space character between the values Orange and Peach. This makes it very difficult to read the results.įor example: SELECT CONCAT('Orange', ' ', 'Peach') Otherwise, you might get a long string with the concatenated values running together. When you are concatenating values together, you might want to add space characters to separate your concatenated values. Result: 'Tech On The Net' Concatenate Space Characters SELECT CONCAT('Tech ', 'On ', 'The ', 'Net') Let's look at some SQL Server CONCAT function examples and explore how to use the CONCAT function in SQL Server (Transact-SQL).įor example: SELECT CONCAT('TechOnTheNet', '.com')
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |