Tag archive
Commands grouped around the same concept, pattern, or recurring problem.
Convert string values to all uppercase or all lowercase using `UPPER` and `LOWER`.
Aggregate multiple string values from grouped rows into a single delimited string.
Return the portion of a string that matches a regular expression pattern, useful for parsing structured text without fixed delimiters.
Return only part of a text value by position and length.
Match string columns against a wildcard pattern using `LIKE`.
Convert a numeric value into a formatted string with a fixed number of decimal places, optionally including thousands separators.
Return the number of characters in a string using `LENGTH` or `LEN`.
Combine multiple text values into one string in the query result.
Convert a text string in a known format into a native DATE value using engine-specific parsing functions.
Substitute all occurrences of a substring with a new value using `REPLACE`.
Expand a comma-separated or delimited string into one row per element, turning a single cell into a proper set of rows.
Remove leading and trailing whitespace from string values with `TRIM`.