Getting first letter of String in SQL

Hi,

How to get the first letter of the whole string through SQL query. For example, my string is
"Welcome to Expert exchange". Now i have to get the first letter of the string like WTEE

Please let me know the way

Thanks
Suriyaraj_SudalaiappanAsked:
Who is Participating?
 
Rajkumar GsConnect With a Mentor Software EngineerCommented:
0
 
sergiobg57Commented:
SELECT SUBSTR(column,1,1) 
FROM table 
WHERE column = codition;

Open in new window

0
 
sdstuberConnect With a Mentor Commented:
upper(regexp_replace(s, '((^| )([^ ]))|.', '\3'))
0
 
Suriyaraj_SudalaiappanAuthor Commented:
GOOD ONE
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.