About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

UPPER

A string function that returns the input expression with all lowercase characters converted to their uppercase equivalents.

UPPER Syntax

UPPER (char)
UCASE (char)

UPPER Example

Input	Output
'loud'	'LOUD'

CREATE TABLE string_table (col1 VARCHAR(20));
INSERT INTO string_table VALUES (UPPER('loud'));
1 row affected
SELECT col1 FROM string_table;
1 row selected
col1
--------------------
LOUD

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

UPPER

UPPER

UPPER Syntax

UPPER Example