Re: sql question

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

"Vern cool"

Is Vern cool better than very cool?

<gd&r>

vhamberg@xxxxxxxxxxx wrote:
> Rob
>
> I believe V5R4 has added some implicit type conversions into SQL, including character representation of numeric variables.
>
> Vern cool!
>
> Vern
>
> -------------- Original message -------------- 
> From: rob@xxxxxxxxx 
>
>   
> > Tim, 
> >
> > Is that number truly numeric? I did create a test file and used that. And 
> > the statement worked. Frankly I was a tad surprised that I could substr a 
> > numeric 
> >
> > You do realize that 
> > 123456 
> > 12345678 
> > 123457 
> > Will all appear as CORP 12345. But a plain 1234 will appear as a new CORP 
> >
> > If that's what you wanted then that's pretty cool. 
> >
> > Rob Berendt 
> > --
> > Group Dekko Services, LLC 
> > Dept 01.073 
> > Dock 108 
> > 6928N 400E 
> > Kendallville, IN 46755 
> > http://www.dekko.com 
> >
> > --
> > 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. 
> >
> >