I want to strip the first letter of each first name and put it in the INITIALS FIELD? How would I do that?
Example: The Initials field is blank so I must put it in by taking the first letter of the persons name(s) and put it in that field. So James Dull Reeves initials would be JD. I know if I use this (SUBSTR(Firstnames,1,1) As Intitals) it gives me the first letter of the persons first name but what if he got 2 first names?
> what if he got 2 first names?
How can a person have two "FIRST" names?
First is First. What comes after first is no longer first.
Simply establish as business rule & be consistent.
How do you plan on handling nicknames?
Well, let me rather say this....... you have a FirstName field which is you name(s) and then your SurName field. My name is for example Shaun David Turner. FirstName field would take "Shaun David" and SurName field would take Turner.
My Initials field is empy now I have to fill it in for him, so my initials would be "S D". How do I populate my Initials field with that value?
Originally posted by shelva
OH!! we were updating parallely.
In your Case First count the number of words by counting Number of Spaces.
Then loop through the name to extract first character of each name.
thanks for the quick reply!!
I thought I would do something similar but I need some example because I am not a Oracle GURU!!! :-)