How to add first name first letter to last name name
By using regular expression replace it is possible to add first letter of name to the beginning of the last name.
SELECT LOWER(regexp_replace('Lucky, Edy E', '(.+)(, )([A-Z])(.+)','\3\1', 1, 1))
FROM DUAL;
Result : elucky
No comments:
Post a Comment