T-SQL CASE Clause: How to specify WHEN NULL

by 
CASE WHEN last_name IS NULL THEN '' ELSE ' '+last_name END

More Related Contents:

  1. SQl CASE Statement
  2. How to calculate age in T-SQL with years, months, and days
  3. Convert multiple rows into one with comma as separator [duplicate]
  4. How to convert Seconds to HH:MM:SS using T-SQL
  5. T-SQL: Selecting rows to delete via joins
  6. Combining INSERT INTO and WITH/CTE
  7. T-SQL Pivot? Possibility of creating table columns from row values
  8. What is a “batch”, and why is GO used?
  9. Getting the minimum of two values in SQL
  10. T-SQL loop over query results
  11. How to insert default values in SQL table?
  12. How to Round a Time in T-SQL
  13. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  14. t-sql get all dates between 2 dates [duplicate]
  15. Check if a varchar is a number (TSQL)
  16. How to pivot table with T-SQL?
  17. Extract the first word of a string in a SQL Server query
  18. Testing for inequality in T-SQL
  19. Can I use the MERGE statement in SQL Server 2005?
  20. Replace a newline in TSQL
  21. T-SQL – function with default parameters
  22. Search for one value in any column of any table inside a database
  23. How to use an Alias in a Calculation for Another Field
  24. Using a cursor with dynamic SQL in a stored procedure
  25. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  26. Convert unix epoch timestamp to TSQL datetime
  27. T-SQL Between Dates Confusion
  28. Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row
  29. String.Format like functionality in T-SQL?
  30. How to parse string into date?

Leave a Comment