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