How to compare strings ignoring case
Use TO_LOWER_CASE
or TO_UPPER_CASE
functions to convert both strings to upper or lower case and then compare them. See also the “Text Functions” section.
Use TO_LOWER_CASE
or TO_UPPER_CASE
functions to convert both strings to upper or lower case and then compare them. See also the “Text Functions” section.