The UPPER function translates a character string literal or column value to all upper case characters. This functions primary use is in SQL expression evaluation where character data in a column can be in mixed case. The syntax for this function is:
UPPER('string'/colname)
Example: UPPER function
In the following example the value of two columns assumed to be mixed-case are translated into uppercase for comparison.
“SELECT NAME FROM SYSTEMS WHERE UPPER(CURRENT_STATE) = UPPER(DESIRED_STATE)”
Only the NAME='IMS' row is selected.
|
Copyright © 2014 CA.
All rights reserved.
|
|