Home Original page

sql-formatter/docs/functionCase.md at master · sql-formatter-org/sql-formatter

Converts function names to upper- or lowercase.

Options

  • "preserve" (default) preserves the original case.
  • "upper" converts to uppercase.
  • "lower" converts to lowercase.

preserve

SELECT
  Concat(Trim(first_name), ' ', Trim(last_name)) AS name,
  Max(salary) AS max_pay,
  Cast(ssid AS INT)
FROM
  employee
WHERE
  expires_at > Now()

upper

SELECT
  CONCAT(TRIM(first_name), ' ', TRIM(last_name)) AS name,
  MAX(salary) AS max_pay,
  CAST(ssid AS INT)
FROM
  employee
WHERE
  expires_at > NOW()

lower

SELECT
  concat(trim(first_name), ' ', trim(last_name)) AS name,
  max(salary) AS max_pay,
  cast(ssid AS INT)
FROM
  employee
WHERE
  expires_at > now()