LOWER

Converts all the letters in a string to lower case.

Syntax

string LOWER(string value)

Example

LOWER("Data Synchronisation Studio")

Will return "data synchronisation studio".

or

To make sure email addresses are only in lower case. For this example we will use the emails "JoHNsmith@CompanYnAmE.co.uk","BLOggsJoe@COMPANYname.com":

LOWER(Email)

Which will return the emails in lower case, "johnsmith@companyname.co.uk" and "bloggsjoe@companyname.com".