Hello,

There are a few other name combinations -

VICKERS BSN RN, LAVERNE

VICKERS BSN RN, LAVERNE S

TENELLE JONES, BSN, RN

MARION M KULINSKI, BSN

MARION M KULINSKI, BSN, RN

VICKERS, LAVERNE

VICKERS, LAVERNE S

That should be...

Drew,

Holy cow this worked perfectly!  Could you walk me through the logic so I can understand exactly why this works?  Much appreciated!

Shel

Thanks so much DesNorton. I real appreciate your reply. I am looking forward to trying both these approaches.

Hi Drew, gaps are possible. Do you know how I would account for gaps in the code?  I really appreciate your help I have been working on this all day...

Here is some sample code to see if that helps.

CREATE TABLE DMELIST(

MAXORDERBY INT,

MONTH_YEAR DATE,

CARRIERMEMID VARCHAR(20),

SERVCODE VARCHAR(10),

LIMIT VARCHAR(50))

INSERT INTO DMELIST (MAXORDERBY,MONTH_YEAR,CARRIERMEMID,SERVCODE,LIMIT) VALUES ('2','1/1/2018','123456789','E0720','1 60 months');INSERT INTO DMELIST (MAXORDERBY,MONTH_YEAR,CARRIERMEMID,SERVCODE,LIMIT) VALUES ('4','2/1/2018','123456789','A4556','3 month');

INSERT...

• This reply was modified 5 years, 8 months ago by  shel 29143.

That is EXACTLY what I was looking for!  Thank you so much and for the quick reply!