UPPER

All functions > STRING > UPPER

Returns the string with all characters converted to uppercase.

Signatures

Returns: String with all characters converted to uppercase

UPPER(string: VARCHAR) → VARCHAR
sql
ParameterTypeRequiredDescription
stringVARCHARYesInput string to convert

Notes

  • Affects only alphabetic characters
  • Non-alphabetic characters remain unchanged
  • Handles Unicode characters correctly

Examples

FeatureQL
SELECT
    f1 := UPPER('hello world'),  -- All lowercase to uppercase
    f2 := UPPER('Mixed Case String'),  -- Mixed case to uppercase
    f3 := UPPER('abc123xyz'),  -- Letters and numbers
    f4 := UPPER('café'),  -- Unicode characters
    f5 := UPPER('123!@#')  -- Numbers and symbols unchanged
;
Result
f1 VARCHARf2 VARCHARf3 VARCHARf4 VARCHARf5 VARCHAR
HELLO WORLDMIXED CASE STRINGABC123XYZCAFÉ123!@#

Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19