</>SnippetSearch. A little code. A lot of possibility.
FIND YOUR NEXT FEW LINES

Results for “Text validation & formatting”

Small, practical examples. Search by task or narrow things down below.

939 snippets foundClear filters
SQL ServerGetting Started

Display a fallback for missing data

SQL Server: Return a supplied label when a column contains NULL.

SQL Server✓ Tested
PostgresGetting Started

Display a fallback for missing data

Postgres: Return a supplied label when a column contains NULL.

Postgres✓ Tested
SQLiteGetting Started

Display a fallback for missing data

SQLite: Return a supplied label when a column contains NULL.

SQLite✓ Tested
CSSInteraction selectors

Display a hint for a truly empty container

CSS: The empty selector requires no element or text children, including whitespace text nodes.

CSS✓ Tested
SQLReporting & grouped calculations

Distinguish row count from non-null value count

SQL: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL✓ Tested
SQL ServerReporting & grouped calculations

Distinguish row count from non-null value count

SQL Server: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQL Server✓ Tested
PostgresReporting & grouped calculations

Distinguish row count from non-null value count

Postgres: COUNT(*) includes every row while COUNT(column) skips NULL values.

Postgres✓ Tested
SQLiteReporting & grouped calculations

Distinguish row count from non-null value count

SQLite: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQLite✓ Tested
SQLWindow analytics

Divide an ordered result into numbered buckets

SQL: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

SQL✓ Tested
SQL ServerWindow analytics

Divide an ordered result into numbered buckets

SQL Server: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

SQL Server✓ Tested
PostgresWindow analytics

Divide an ordered result into numbered buckets

Postgres: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

Postgres✓ Tested
SQLiteWindow analytics

Divide an ordered result into numbered buckets

SQLite: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

SQLite✓ Tested