Re: Question on ALTSEQ(CASETBL)

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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