Replacing NULL and empty string within Select statement

by

Try this

COALESCE(NULLIF(Address.COUNTRY,''), 'United States')

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. SQL Server dynamic PIVOT query?
  3. SQL Server – Best way to get identity of inserted row?
  4. Should I use != or for not equal in T-SQL?
  5. How to update two tables in one statement in SQL Server 2005?
  6. SQL Server Process Queue Race Condition
  7. Create a date from day month and year with T-SQL
  8. How should I pass a table name into a stored proc?
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. SQL – Subtracting a depleting value from rows
  11. SELECT FOR UPDATE with SQL Server
  12. Compare DATETIME and DATE ignoring time portion
  13. Easiest way to populate a temp table with dates between and including 2 date parameters
  14. How to group by month from Date field using sql
  15. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  16. What is the difference between SQL, PL-SQL and T-SQL?
  17. What is the equivalent of ‘describe table’ in SQL Server?
  18. Create a SQL query to retrieve most recent records
  19. Curly braces in T-SQL
  20. Find min and max for subsets of consecutive rows – gaps and islands
  21. Update query using Subquery in Sql Server
  22. T-SQL: checking for email format
  23. SQL Server search using like while ignoring blank spaces
  24. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  25. How do I compare two columns for equality in SQL Server?
  26. Flattening of a 1 row table into a key-value pair table
  27. SQL Server equivalent of WM_CONCAT function [duplicate]
  28. Distributed transaction error?
  29. Should every SQL Server foreign key have a matching index? [closed]
  30. Determine what user created objects in SQL Server

Leave a Comment