Survey Tabulation > Advanced expressions > UNICOM Intelligence function library > Text functions > LCase
 
LCase
Returns a string that has been converted to lower case.
Syntax
LCase(Val)
Parameters
Val
Type: Text
Text value to be converted to lower case.
(return)
Type: Text
Lowercase copy of Val.
Remarks
The input string is converted to lower case, according to the rules of the input locale.
If the current data value is NULL, Val is "" and the return value is "".
How you specify a text string as an argument depends on whether you are using the function in an SQL query or in mrScriptBasic or mrScriptMetadata. In an SQL query, enclose text strings in single quotation marks (' '). In mrScriptBasic or mrScriptMetadata, enclose text strings in double quotation marks (" ").
Example
This example uses the LCase function to return a copy of the contents of the address variable converted to lower case:
address.LCase()
For a mrScriptBasic example that uses LCase, see 2: Getting a list of valid languages.
See also
Text functions