Re: SQL function equivalent to TestN?

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Why emulate TESTN?  It doesn't actually work very well.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

> On Dec 22, 2016, at 10:59 AM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:
>
> Michael,
>
> AFAIK, the answer is no, but you could create a function that emulates
> TestN...
>
> Regards,
> Luis
>
> Sent from my Moto G phone. Please excuse my brevity.
>
> On Dec 22, 2016 11:47, "Koester, Michael" <mkoester@xxxxxxxxxxxxx> wrote:
>
> > Is there anything in SQL that can test a string for a valid numeric?
> > I am looking to extract the minimum value from a character column in
> > selected rows, but I only want to consider those where the column has a
> > numeric value.
> > Simplified, I'm looking for something like:
> >
> > Exec sql
> > select min(columnOfwhoKnowsWhat)
> > from table1
> > where [columnOfwhoKnowsWhat (a 10-character field) only contains some
> > whole number between 1 and 99,999 (possibly with a comma) ];
> >
> > The column I need to test is a number of feet from a location, but being a
> > "miscellaneous" field, may instead have all manner of other data instead,
> > including values with more than one decimal point, e.g. ".057 .034 .032"
> > (yeah, there's even an embedded space).
> >
> > I know I can declare a cursor, fetch each row and test with RPG, but if
> > SQL can do it, that would be preferable.
> >
> > Had to ask...
> > Thanks.
> >
> > Michael Koester
> >
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> > mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-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 RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-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