Answers for "write a query to get the first 4 characters of “first_name” column in upper case."

get first 3 letters in sql

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Posted by: Guest on January-28-2021

how to get capital letter first in sql

INITCAP retrieves capital letter first

Posted by: Guest on January-28-2021

Code answers related to "write a query to get the first 4 characters of “first_name” column in upper case."