Category: 04. String Function
-
LOWER
Description: Converts all characters in a string to lowercase.Purpose: Standardizing data for comparisons.Syntax: LOWER(string)Parameters: Takes one string parameter.Returns: The string converted to lowercase.Example: LOWER(‘WORLD’) returns ‘world’.Notes: Affects all characters in the string.Use Case: Ensuring consistency in email addresses.
-
UPPER
Description: Converts all characters in a string to uppercase.Purpose: Standardizing data for comparisons.Syntax: UPPER(string)Parameters: Takes one string parameter.Returns: The string converted to uppercase.Example: UPPER(‘hello’) returns ‘HELLO’.Notes: Affects all characters in the string.Use Case: Ensuring consistent case in user inputs.