Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
SQL

SQL: Use COALESCE for First Non-Null Value

- 07.06.26 - ErcanOPAK

📋 COALESCE is NVL2, ISNULL, and IFNULL Combined

Need first non-null value? COALESCE takes multiple arguments, returns first non-null. Works across all databases.

📝 Basic COALESCE

-- Return first non-null
SELECT COALESCE(null, null, 'first', 'second');
-- Returns 'first'

SELECT COALESCE(phone, mobile, email, 'No contact');
-- Returns phone if not null, else mobile, else email, else default

-- Default value for NULL
SELECT name, COALESCE(age, 0) as age FROM users;

-- Multiple columns preference
SELECT 
    COALESCE(work_email, personal_email, 'no-email') as contact_email
FROM employees;

🎯 Real-World Examples

-- Priority contact
SELECT 
    name,
    COALESCE(mobile, home_phone, work_phone, 'No phone') as primary_phone
FROM contacts;

-- Price calculation (list > sale > cost)
SELECT 
    product_name,
    COALESCE(sale_price, list_price, cost_price) as final_price
FROM products;

-- User display name (nickname > first name > username)
SELECT 
    COALESCE(nickname, first_name, username) as display_name
FROM users;

-- Pivot with defaults
SELECT 
    id,
    COALESCE(col1, col2, col3, 0) as value
FROM data;

💡 COALESCE vs ISNULL

  • COALESCE: ANSI standard, works everywhere, N arguments
  • ISNULL: SQL Server only, 2 arguments only
  • NVL: Oracle only, 2 arguments
  • IFNULL: MySQL only, 2 arguments
  • COALESCE is portable: Use it for cross-database queries

“Three phone columns. Need primary contact. COALESCE picks first non-null. One line instead of nested CASE statements. Clean and simple.”

— SQL Developer

Related posts:

SQL Server: Fix New Deadlocks Appearing Only After Raising the Isolation Level Because Range Locks N...

SQL Server: Fix New Deadlocks Appearing Only After Raising the Isolation Level Because Range Locks N...

SQL Server: Why a Table Variable Gets a Far Worse Execution Plan Than the Same Query With a Temp Tab...

SQL Server: Why a Table Variable Gets a Far Worse Execution Plan Than the Same Query With a Temp Tab...

SQL Server — GETDATE() Breaks Deterministic Queries

SQL Server — GETDATE() Breaks Deterministic Queries

Views: 14

Post navigation

.NET Core: Enable Response Compression for Smaller Payloads
C#: Use ^ and .. for Indexing from End and Ranges

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (653)
  • Add Constraint to SQL Table to ensure email contains @ (609)
  • Average of all values in a column that are not zero in SQL (570)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (547)
  • Find numbers with more than two decimal places in SQL (475)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit
  • SQL Server: Fix ROW_NUMBER Ties Reordering Between Identical Runs
  • C#: Fix an Enum HasFlag Returning True for the Zero Value
  • WordPress: Fix Featured Images Vanishing After a CDN Migration
  • Photoshop: Fix Content-Aware Fill Smearing a Repeating Pattern
  • Asp.Net Core: Fix Antiforgery Tokens Rejected Behind a Reverse Proxy

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,055)
  • Get the User Name and Domain Name from an Email Address in SQL (981)
  • How to add default value for Entity Framework migrations for DateTime and Bool (977)
  • Get the First and Last Word from a String or Sentence in SQL (858)
  • How to select distinct rows in a datatable in C# (854)

Recent Posts

  • C#: Fix a ConditionalWeakTable Entry Vanishing Too Soon
  • Docker: Fix a Stale COPY Layer After Editing .dockerignore
  • Photoshop: Fix a Pattern Overlay Scaling Wrong on a High-DPI File
  • SQL Server: Fix a Computed Column Index Skipped by Implicit Cast
  • HTML5: Fix a required Input Inside a Hidden Tab Blocking Submit

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com