SQL Server String Concatenation with Null

by

You can use ISNULL(....)

SET @Concatenated = ISNULL(@Column1, '') + ISNULL(@Column2, '')

If the value of the column/expression is indeed NULL, then the second value specified (here: empty string) will be used instead.

More Related Contents:

  1. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  2. Altering a column: null to not null
  3. How much size “Null” value takes in SQL Server
  4. What is the PostgreSQL equivalent for ISNULL()
  5. Updating image in VB and SQL Server not working [closed]
  6. Where clause not working in sql server
  7. Compare the values of column in SQL Server
  8. T-SQL stored procedure that accepts multiple Id values
  9. How do I escape a percentage sign in T-SQL?
  10. Get list of databases from SQL Server
  11. When/Why to use Cascading in SQL Server?
  12. SQL Update with row_number()
  13. SQL Server – Dynamic PIVOT Table – SQL Injection
  14. Preserving ORDER BY in SELECT INTO
  15. Is a single SQL Server statement atomic and consistent?
  16. SQL Server file names vs versions [closed]
  17. How to add xml encoding to xml Output in SQL Server
  18. What are the differences between a clustered and a non-clustered index?
  19. Unable to begin a distributed transaction
  20. Difference between #temptable and ##TempTable?
  21. How to add custom attributes to SQL connection string?
  22. Compute MD5 hash of a UTF8 string
  23. Sort Bullets in Database
  24. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  25. How do I remove non-breaking spaces from a column in SQL server?
  26. Why is casting from float to varchar being rounded in SQL Server?
  27. SQL SERVER PIVOT table with joins and dynamic columns
  28. SQL Server 2008 can’t login with newly created user
  29. Update SQL with consecutive numbering
  30. Nested transactions in Sql Server

Leave a Comment