sql get value capital letter and lowercase code example

Example 1: uppercase and lowercase in sql

select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');

Example 2: how to get capital letter first in sql

INITCAP retrieves capital letter first