Tags
MySQL , UCASE
Asked 2 years ago
31 May 2022
Views 940
kiran

kiran posted

what is the use of UCASE in MySQL?

what is UCASE in MySQL ? how to use function UCASE in MySQL?
ruby-rails

ruby-rails
answered May 31 '22 00:00

The UCASE function converts a given string or character to upper case( lower case to upper case ) and the UCASE function works with static string and given string field as well.


select ucase('a')


above query returns "A"(upper case of 'a')
Edit Answer
sqltreat

sqltreat
answered Jun 2 '22 00:00

The UCASE function and the UPPER function both give the same result, The UCASE function and the UPPER function convert string so lower case to upper case.
you can use UPPER() instead of the UCASE() also.
Edit Answer
Post Answer
OMG!   You need to Login / Register to Post Answer
[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic