concatenate two database columns into one resultset column

by

The SQL standard way of doing this would be:

SELECT COALESCE(field1, '') || COALESCE(field2, '') || COALESCE(field3, '') FROM table1

Example:

INSERT INTO table1 VALUES ('hello', null, 'world');
SELECT COALESCE(field1, '') || COALESCE(field2, '') || COALESCE(field3, '') FROM table1;

helloworld

More Related Contents:

  1. How to delete 0 values but not blanks from a column in SQL Server 2008 programming?
  2. Is there a way to access the “previous row” value in a SELECT statement?
  3. What this query does to create comma delimited list SQL Server?
  4. SQL Server – Return value after INSERT
  5. SQL NVARCHAR and VARCHAR Limits
  6. How to group time by hour or by 10 minutes
  7. SQL query to insert datetime in SQL Server
  8. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  9. Convert Xml to Table SQL Server
  10. How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]
  11. SQL Server : dynamic pivot over 5 columns
  12. How to create table using select query in SQL Server?
  13. How do I remove redundant namespace in nested query when using FOR XML PATH
  14. T-SQL and the WHERE LIKE %Parameter% clause
  15. Custom aggregate function (concat) in SQL Server
  16. Combine two columns and add into one new column
  17. Which SQL query is faster? Filter on Join criteria or Where clause?
  18. UPDATE and REPLACE part of a string
  19. Improve SQL Server query performance on large tables
  20. Average of multiple columns
  21. Show all rows that have certain columns duplicated
  22. Select SQL Server database size
  23. Check if a parameter is null or empty in a stored procedure
  24. Cannot Resolve Collation Conflict
  25. Execute sp_executeSql for select…into #table but Can’t Select out Temp Table Data
  26. Display next event date
  27. Select rows where column value has changed
  28. Issues with SQL comparison and null values
  29. How do you read XML column in SQL Server 2008?
  30. Sql query for tree table

Leave a Comment