Re: SQL is numeric function

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

LOL - I was taking a piercing glance at the obvious!

On 1/15/2013 12:38 PM, Stone, Joel wrote:
> Yes, but first I have to locate them!
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
> Sent: Tuesday, January 15, 2013 12:36 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: SQL is numeric function
>
> Hi again
>
> It would be a good idea, I think, to find out why a numeric (packed?
> zoned?) field has blanks.
>
> HTH
> Vern
>
> On 1/15/2013 10:50 AM, Stone, Joel wrote:
> > Does Iseries SQL have a numeric test?
> >
> > For example:
> >
> > Runsql 'select * from ItemMaster where itemNbr is not numeric'
> >
> >
> >
> > ______________________________________________________________________
> > This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
> > For more information please visit http://www.symanteccloud.com
> > ______________________________________________________________________