Re: Is there an SQL equivalent of RPG's %check?

[Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>]

Yes !!

You can use REGEXP_INSTR to look after valid/invalid chars;

https://www.ibm.com/docs/en/i/7.3?topic=functions-regexp-instr


On Thu, Aug 12, 2021 at 10:51 PM Peter Dow <petercdow@xxxxxxxxx> wrote:

> I'm looking for a way to test each character of a VARCHAR field for a
> value less than x'40'.
>
> If there's no standard way, I can always write a UDF.
>
> --
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
> pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx>
>
> /
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com