Contents

COALESCE 排除空字串方法

malagege included in SQL

2022-07-31 23 words One minute

Contents

之前有寫過mysql COALESCE 取代null值好方法 | 程式狂想筆記
最近遇到筆記一下。

1

SELECT COALESCE(NULLIF(Other,''),Industry) Ind FROM registration

sql server - SQL Coalesce with empty string - Stack Overflow