DOWNSHIFT( )

The DOWNSHIFT( ) function returns a string value in which all uppercase characters in its argument are converted to lowercase.

The DOWNSHIFT( ) function is typically called to regularize character data. You might use it, for example, to prevent the state abbreviation TX, Tx or tx from resulting in different values, if these were logically equivalent in the context of your application.

Non-alphabetic or lowercase characters are not altered by DOWNSHIFT( ). The maximum length of the returned character string value is 511 bytes.

You can use the DOWNSHIFT( ) function in an expression (where such usage is allowed), or you can assign the value returned by the function to a variable.

Reference

UPSHIFT( )