difference between upper and lower

SQL UPPER() function converts all the characters in a string into uppercase.