-
Removing middle initials
For this query there are many first and last names with some having middle initials with a '.' at the end.
Current result:
Hong, Amy L.
Jackson, Yuri K.
Nguyen, Roy
Desired:
Amy Hong
Yuri Jackson
Roy Nguyen
How can I achieve this with SQL Plus?
Thanks.
-
Search for second space in the name using INSTRING function, and use the character position to get substring of name.
select substr(name,1,instr(name,' ',2))
from table
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|