Results for “CASE”
Small, practical examples. Search by task or narrow things down below.
Normalize ASCII text to lowercase
SQLite: LOWER is useful for display normalization; indexed case-insensitive search depends on the database collation and schema.
SQLite✓ Tested
Normalize ASCII text to uppercase
SQL: UPPER changes character case under the database’s text rules.
SQL✓ Tested
Normalize ASCII text to uppercase
SQL Server: UPPER changes character case under the database’s text rules.
SQL Server✓ Tested
Normalize ASCII text to uppercase
Postgres: UPPER changes character case under the database’s text rules.
Postgres✓ Tested
Normalize ASCII text to uppercase
SQLite: UPPER changes character case under the database’s text rules.
SQLite✓ Tested
Normalize identifier case consistently
JavaScript: Use toLowerCase for a simple case-insensitive ASCII identifier lookup.
JavaScript✓ Tested
Normalize identifier case consistently
TypeScript: Use toLowerCase for a simple case-insensitive ASCII identifier lookup.
TypeScript✓ Tested
Search text without case sensitivity
Linux Commands: Use grep -i to match uppercase and lowercase variants.
Linux Commands✓ Tested
Search text without case sensitivity
Match a pattern with PostgreSQL ILIKE.
ILIKE✓ Tested
Translate ASCII lowercase letters to uppercase
Linux Commands: Use tr under a fixed locale for predictable ASCII character ranges.
Linux Commands✓ Tested
Use case-insensitive dictionary keys
C#: Choose an ordinal comparer when case-insensitive keys represent identifiers.
C#✓ Tested
Classify a filename with shell patterns
Bash Scripts: Case patterns support alternatives without launching an external regex tool.
Bash Scripts✓ Tested