× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. July 2011

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.