RE: [sqr-users] How to extract the suffix from name

["the dragon" <ceprn@hotmail.com>]

subbu,

What version of PeopleSoft?  Yiou may be going after the wrong field.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

All,
Iam trying to write a fixed length flat file and have a field suffix to be 
populated in the file,
The source for this suffix is the Personal_Data.Name (The Name is stored in 
this format,
lastname sufix,firstname)...What i need to get is suffix.The valid values 
for the suffix are
'I I','I I I','I V','II','III','IV','Jr','Jr.','JR','Ms.','Sr','Sr.'
I would appreciate if some one can tell me how to extract this suffix from 
the name field.
Thanks in advance,
Subbu



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users