Friday, September 4, 2015

How to get every first letter from a string ?




SELECT REGEXP_REPLACE('KUMAR SHIVAM MYTHASS','(^| )([^ ])([^ ])*','\2') FIRST_LETTERS FROM DUAL;


FIRST_LETTERS
-------------
KSM

No comments:

Post a Comment