Removing Spaces from Concatenated SQL Values: A Guide to Efficient Solutions

Creating Custom Id Using the Concatenation of Three Columns in SQL Server with concat() vs concat_ws()