how to get initials in sql
Solutions on MaxInterview for how to get initials in sql by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "how to get initials in sql"
Dario
06 May 2017
1SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
2 , SUBSTR(FIRST_NAME , 1,1) || SUBSTR(LAST_NAME , 1,1) AS INITIALS
3FROM EMPLOYEES ; similar questions
how to get capital letter first in sqlhow to fetch first 5 characters in sqlwrite sql query to show the details start from digitget first 2 letter in sqldefault constraint in ms sqltsql get beginning of yearsql server current datesql first characterget statis values sqlsql server get current datehow to to get time in sqlcapitalize 1st letter in sql serverget first 3 letters in sqlsql case sttement with setget first name and last name from full name string in sqlget first 3 letter of department name in sqlget first n letter of department name in sqlinitcap in sqlsql default your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful