INITCAP

1
SELECT
2
  INITCAP(full_name) as formatted_name
3
FROM (
4
  SELECT 'budi SANTOSO' as full_name UNION ALL
5
  SELECT 'ANI DEWI lestari' UNION ALL
6
  SELECT 'EKO prasetyo'
7
);

1
SELECT
2
  original_title,
3
  INITCAP(original_title) as formatted_title
4
FROM articles;

1
SELECT
2
  INITCAP(LOWER(street)) as street,
3
  INITCAP(LOWER(city)) as city
4
FROM addresses
5
WHERE city = 'JAKARTA';