Re: Using SQL to group records with similar elements

RE: Thanks for your reply Chuck

Boy - it's going to be just ONE of those days
Somehow in thanking Chuck, I replaced the Subject line
So I reposted my last 2 e-mail answers here

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

From: Alan Shore
Sent: Thursday, July 21, 2011 1:47 PM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: RE: Thanks for your reply Chuck

As per my modus operandi, I forgot to mention the release level, and that would be V5r4

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

From: Alan Shore
Sent: Thursday, July 21, 2011 1:46 PM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Thanks for your reply Chuck

The fields in question are all 3 byte alpha fields, containing either blanks or numbers, in my example
Key field1 field2 field3 field4 field5 field6 field7 etc.-->
00001 360 160 202 400 118
00002 160
00003 400 202 600
00004 160 118
00005 202
00006 400
00007 111

For key = 00001
Field1 = '360'
Field6 = ' '

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill