Original subtitles

0 The next function is 1

Upper and lower functions 2

Upper and lower function are used to convert the characters to a specified case so upper will change it to uppercase 3

lower will change all the characters in the string to lowercase 4

and the syntax is also similar to length 5

You just right upper and you give the string in parentheses 6

So whatever string you provide within this parenthesis will be converted to the 7

Uppercase 8

If you write lower, it will be converted to lowercase 9

This will basically be used 10

Whenever you are matching strings 11

Sometimes some part of the data is in some case and the other part of data is in some other case 12

so just to maintain uniformity 13

We'll use upper everywhere so upper 14

some part of string you can match with other part of string 15

So both the strings will be in upper case so that there is no mismatch due to difference in case 16

So that's where you you can use upper and lower cases 17

Otherwise you can just use uppercase 18

Whenever you want to change all the characters to uppercase 19

So, as an example you can just 20

Convert this 21

String of Start-Tech Academy 22

To uppercase 23

Or you can 24

Convert the whole string to lowercase let's go and try this 25

We will select 26

and we'll write upper 27

The bracket will say Start-Tech Academy you can see only the first 28

Characters of the words are in uppercase right now 29

When you run this query 30

The output will be 31

All characters are in uppercase 32

you can see 33

All characters are in uppercase you can update tables using this output 34

so that's how this function will help you. select lower 35

Start-Tech Academy 36

so the 1st characters which are in uppercase 37

Will now be in 38

lower case 39

let's run this 40

Everything is in lowercase 41

So that's the use of 42

Upper and lower function