`lowercase(X)`

Returns a given string converted to all lowercase.

Syntax

lowercase(X)

Input

Argument	Type	Description
`X`	text	A scalar value or the name of a column

Return Value

Returns a text value corresponding to the input string in all lowercase.

If X is N/A, the result is N/A.

Sample Usage


`value`	`lowercase(value)`
'BaNana'	'banana'

Example

In the "Product Master" table (pub.demo.retail.prod), you can convert the department descriptions to lowercase. To do this, create a computed column and apply the lowercase(X) function to the deptdesc column.

<base table="pub.demo.retail.prod"/>
<willbe name="example" value="lowercase(deptdesc)"/>
<colord cols="deptdesc,example"/>

The values in the deptdesc column are converted to lowercase.

Additional Information

This function does not work with Unicode (UTF-8) strings.
For a Unicode-compliant alternative, consider strdowncase(X).