UPPER(expr)
Convert text to uppercase.
Open →SQL String Functions
Cross-dialect SQL text and formatting function equivalents with live examples and output. Open each dedicated function page for automatic live output and examples.
Viewer Index · Tools Index · 68 functions
LOWER(expr)
Convert text to lowercase.
Open →TRIM(expr)
Trim leading and trailing whitespace or chosen characters.
Open →LTRIM(expr)
Trim the left side of input text.
Open →RTRIM(expr)
Trim the right side of input text.
Open →LENGTH(expr) / LEN(expr)
Return the length of text input.
Open →SPLIT_PART()/STRING_SPLIT()
Split text using a delimiter and optional limit.
Open →STRING_AGG()/LISTAGG()
Join list-style input using a delimiter.
Open →REPLACE(expr, search, repl)
Replace target text with another value.
Open →SUBSTRING(expr, start, len)
Extract a substring using start and optional length.
Open →POSITION()/CHARINDEX()/INSTR()
Find first index of a substring.
Open →Last Index Of
Find last index of a substring.
Open →LIKE 'prefix%'
Compare text prefix using a target value and length.
Open →Substring From Match
Return text from first case-sensitive match.
Open →Substring From Match (Case-Insensitive)
Return text from first case-insensitive match.
Open →Substring Count
Count occurrences of a substring.
Open →Padi Okun
Pad text left/right/both to a target width.
Open →Paadi Bẹrẹ
Pad the start of a string.
Open →Pad End
Pad the end of a string.
Open →Lowercase First Character
Lowercase the first character.
Open →Capitalize First Character
Uppercase the first character.
Open →Title Case
Uppercase first letter of each word.
Open →Sentence Case
Convert words to sentence case.
Open →Camel Case
Convert input to camelCase.
Open →Snake Case
Convert input to snake_case.
Open →Kebab Case
Convert input to kebab-case.
Open →Translate Map
Apply character/string mapping replacements.
Open →Ipari Ọrọ
Wrap long text to a fixed width.
Open →Chunk Split
Split text into fixed-length chunks.
Open →Count Characters
Count character/code point frequencies.
Open →Character From Code Point
Create text from numeric code points.
Open →Code Point Of First Character
Get code point of first character.
Open →Text To Hex
Convert text bytes to hexadecimal.
Open →Hex To Text
Decode hexadecimal input to text/bytes.
Open →CONV(hex,16,10)
Convert hexadecimal input to decimal text.
Open →TO_BASE64()
Encode UTF-8 text as Base64.
Open →FROM_BASE64()
Decode Base64 input to UTF-8 text.
Open →URL Encode Component
URL-encode a URI component.
Open →URL Decode Component
URL-decode a URI component.
Open →Encode URI
Encode a full URI.
Open →Decode URI
Decode a full URI.
Open →Parse Query String
Parse query-string text into key/value output.
Open →REGEXP_LIKE()/~
Run regex match and show groups.
Open →Regex Match All
Run regex global match and return all matches.
Open →REGEXP_REPLACE()
Replace regex matches in input.
Open →JSON_VALUE()/JSON_EXTRACT()
Parse JSON text and pretty-print output.
Open →Okun kika
Apply printf-style placeholders to arguments.
Open →FORMAT()/TO_CHAR()
Format decimal values with separators.
Open →TO_CHAR()/FORMAT_DATETIME()
Format date/timestamp values using tokens.
Open →MD5(expr)
Generate MD5 hash for text input.
Open →Levenshtein Distance
Compute edit distance to a target string.
Open →String Similarity
Estimate similarity ratio with a target string.
Open →Soundex
Generate soundex phonetic code.
Open →ROT13
Apply ROT13 substitution cipher.
Open →Sisọ Tags
Remove HTML/XML tags from input.
Open →Escape HTML
Escape text for safe HTML display.
Open →Unescape HTML
Decode HTML entities to text.
Open →Split Lines
Split text into lines with optional line endings.
Open →Expand Tabs
Replace tab characters with spaces.
Open →Zero Fill
Left-pad numeric text with zeros.
Open →Left Justify
Left-justify text to fixed width.
Open →Right Justify
Right-justify text to fixed width.
Open →Aarin
Center text with fill characters.
Open →Remove Prefix
Remove a prefix if it exists.
Open →Yọ Suffix kuro
Remove a suffix if it exists.
Open →Ìpín
Split into (before, separator, after) at first separator.
Open →Reverse Partition
Split into (before, separator, after) at last separator.
Open →Syllable Division (Heuristic)
Approximate syllable splitting for words.
Open →