What it does: The UPPER() Function converts text to lowercase.
Plain English: Simple. This function converts text to be all uppercase.
- So “inCOme” would become “INCOME”.
- “stats” would become “STATS”
Similar to LOWER(), this is a great little function to make text strings equal while you compare them. You may have instances where you want everything to be capitalized. However, UPPER() is probably more likely to be used to capitalize important parts of the text, titles, or things you want to draw people’s eyes to first.
- Text – The text you want to convert to uppercase.