Select a column if other column is null

by

You need the ISNULL function.

SELECT ISNULL(a, b)

b gets selected if a is null.

Also, you can use the WHEN/THEN select option, lookup in BOL. Essentially: its c switch/case block meets SQL.

More Related Contents:

  1. Calculate a Running Total in SQL Server
  2. Not equal != operator on NULL
  3. SET NOCOUNT ON usage
  4. How can I get column names from a table in SQL Server?
  5. How can I select the first day of a month in SQL?
  6. Truncate (not round) decimal places in SQL Server
  7. Select statement to find duplicates on certain fields
  8. Is it possible to specify condition in Count()?
  9. Getting only Month and Year from SQL DATE
  10. Update records in table from CTE
  11. Dynamic Pivot Columns in SQL Server
  12. WHERE Clause vs ON when using JOIN
  13. Is it possible to select sql server data using column ordinal position
  14. Selecting N rows in SQL Server
  15. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  16. How can I INSERT data into two tables simultaneously in SQL Server?
  17. SQL “select where not in subquery” returns no results
  18. How can a LEFT OUTER JOIN return more records than exist in the left table?
  19. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  20. Dynamic SQL to generate column names?
  21. Pivot data in T-SQL
  22. Column name or number of supplied values does not match table definition
  23. Split one column value into multiple column values
  24. How to find consecutive rows based on the value of a column?
  25. T-SQL – Aliasing using “=” versus “as” [closed]
  26. Which SQL query is faster? Filter on Join criteria or Where clause?
  27. SQL Query – Concatenating Results into One String [duplicate]
  28. Know relationships between all the tables of database in SQL Server
  29. How to escape square brackets inside square brackets for field name
  30. Convert bigint to datetime

Leave a Comment