UPPER(expr)
Convert text to uppercase.
Open →Cross-dialect SQL text and formatting function equivalents with live examples and output. Open each dedicated function page for automatic live output and exampレ。
Viewer Index · Tools Index · 68 functions
Convert text to uppercase.
Open →Convert text to lowercase.
Open →Trim leading and trailing whitespace or chosen characters.
Open →Trim the left side of input text.
Open →Trim the right side of input text.
Open →Return the length of text input.
Open →Split text using a delimiter and optional limit.
Open →Join list-style input using a delimiter.
Open →Replace target text with another value.
Open →Extract a substring using start and optional length.
Open →Find first index of a substring.
Open →Find last index of a substring.
Open →Compare text prefix using a target value and length.
Open →Return text from first case-sensitive match.
Open →Return text from first case-insensitive match.
Open →Count occurrences of a substring.
Open →Pad text left/right/both to a target width.
Open →Pad the start of a string.
Open →Pad the end of a string.
Open →Lowercase the first character.
Open →Uppercase the first character.
Open →Uppercase first letter of each word.
Open →Convert words to sentence case.
Open →Convert input to camelCase.
Open →Convert input to snake_case.
Open →Convert input to kebab-case.
Open →Apply character/string mapping replacements.
Open →Wrap long text to a fixed width.
Open →Split text into fixed-length chunks.
Open →Count character/code point frequencies.
Open →Create text from numeric code points.
Open →Get code point of first character.
Open →Convert text bytes to hexadecimal.
Open →Decode hexadecimal input to text/bytes.
Open →Convert hexadecimal input to decimal text.
Open →Encode UTF-8 text as Base64.
Open →Decode Base64 input to UTF-8 text.
Open →URL-encode a URI component.
Open →URL-decode a URI component.
Open →Encode a full URI.
Open →Decode a full URI.
Open →Parse query-string text into key/value output.
Open →Run regex match and show groups.
Open →Run regex global match and return all matches.
Open →Replace regex matches in input.
Open →Parse JSON text and pretty-print output.
Open →Apply printf-style placeholders to arguments.
Open →Format decimal values with separators.
Open →Format date/timestamp values using tokens.
Open →Generate MD5 hash for text input.
Open →Compute edit distance to a target string.
Open →Estimate similarity ratio with a target string.
Open →Generate soundex phonetic code.
Open →Apply ROT13 substitution cipher.
Open →Remove HTML/XML tags from input.
Open →Escape text for safe HTML display.
Open →Decode HTML entities to text.
Open →Split text into lines with optional line endings.
Open →Replace tab characters with spaces.
Open →Left-pad numeric text with zeros.
Open →Left-justify text to fixed width.
Open →Right-justify text to fixed width.
Open →Center text with fill characters.
Open →Remove a prefix if it exists.
Open →Remove a suffix if it exists.
Open →Split into (before, separator, after) at first separator.
Open →Split into (before, separator, after) at last separator.
Open →Approximate syllable splitting for words.
Open →