I am looking for some PL SQL code to string off the a part of the Last Name field
the entry may look like this :
"de la Rosa Martinez Jr" or like "de la Rosa Martinez Rodriguez III"
I like the last name and the Suffix separated. Suffix values would be "Jr, Sr, II, III etc".