22-SELECT for each of the following Case-Manipulation functions
LOWER, UPPER, INITCAP
Select Lower ('saleh') from Employee;
Select Upper ('saleh') from Employee;
Select initcap ('saleh') from Employee;
Select d_name
From Employee
Where Lower(Fname)='saleh';
Select d_name
From Employee
Where upper(Fname)='SALEH';
Select upper(Fname),Lower(mname)
From Employee
Select*
From Employee
Where initcap(FNAME)='Nassar';
Select upper(FNAME) from Employee;
Select lower(Fname)
Form Employee;
23SELECT for each of the following Character-Manipulation functions:
CONCAT, SUBSTR, LENGTH, INSERT, LPAD, RPAD, REPLACE, TRIM.
Select concat ('saleh',ahmed');
From Employee;
Select substr(Fname,1,3);
From Employee;
Select Length (mname)
From Employee;
Select Lpad('saleh',9,'*');
