![]() This will prevent our values from being squished together. ![]() ![]() In this example, we have used the + operator to add a space character between the values Jane and Smith. We can concatenate a space character using the + operator.įor example: SELECT 'Jane' + ' ' + 'Smith' This makes it very difficult to read the results. 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 Let's look at some SQL Server + operator examples and explore how to use the + operator in SQL Server (Transact-SQL).įor example: SELECT 'TechOnTheNet' + '.com'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |