sqlcmd.net validated sql reference

Tag archive

#nullif

Commands grouped around the same concept, pattern, or recurring problem.

1 commands with this tag Browse related patterns quickly
intermediate null-handling MySQL MariaDB SQL Server PostgreSQL SQLite

Return NULL When Two Values Are Equal With NULLIF

Use `NULLIF` to convert a specific value to `NULL`, most commonly to prevent division-by-zero errors.