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

["Knapp, Richard" <KnappR@umsystem.edu>]

I would put all the valid suffixes in an array and do an
instr(the_full_name,element(#),1) for each of them for each name you
need to process.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
subrahmanyam Uppuganti
Sent: Monday, September 13, 2004 11:23 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] How to extract the suffix from name

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
 
 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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

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