All language subtitles for 2. UPPER LOWER

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