LOWER

The LOWER Function

Function Group: Text

LOWER converts a given string to lowercase.

Syntax

LOWER(arg1)

• arg1 is the string to be lowercased

Uses

If we get a response with a string that we would prefer lowercased, we can easily use LOWER:

{  
   "data":{  
      "trip":{  
         "summary": "TRIP WAS GOOD AS MEASURED BY STANDARD METRICS"
      }
   }
}

To make it lowercase, we can use LOWER:

LOWER(data.trip.summary)

which returns "trip was good as measured by standard metrics".

Notes

For a function that sets all characters in a string to uppercase, use UPPER