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".