RE: Question on ALTSEQ(CASETBL)

Glad to be of help.

Sometimes it helps to ask someone who is detached from the problem at hand
(which is one of the reasons this forum is such a wonderful resource)

Regards,
Luis

Sent from my Moto G phone. Please excuse my brevity.

On Jun 15, 2017 11:05 AM, "Alan Shore" <ashore@xxxxxxxx> wrote:

Thanks for your reply Luis
Don't know why I didn't think of that myself - one dopeslap to me

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Luis Rodriguez
Sent: Thursday, June 15, 2017 11:03 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Question on ALTSEQ(CASETBL)

An SQL view with UPPER (), perhaps?

Sent from my Moto G phone. Please excuse my brevity.

On Jun 15, 2017 10:57 AM, "Alan Shore" <ashore@xxxxxxxx> wrote:

Hi everyone
Before I forget - we are on V7r1
We have a file that contains numerous records of phrases we need to
compare to A logical over this file uses ALTSEQ(CASETBL) which in the
logical, "converts" mixed case to all upper case However - this is
true for all 3 fields on the record My question is - is there anything
available to convert 1 (or 2) of the 3 fields to upper case and leave
the other field(s) as mixed case I did google ALTSEQ(CASETBL) but no
success in what I was looking for - probably because it cannot be done

As always - all responses gratefully accepted

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD