Re: QRY : I want to transform string to number ?

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

At 11:36 AM 8/20/97 +0200, Rémi CHAPDELAINE wrote:
>In some files I have fields in string format, but there are numbers inside
>(I cannot change these file because they are part of a product)
>I would like to extract informations from these fields, but get it into
>decimal format (to send them to Excel in the proper format, for example)
>
>I found nothing in QRY function
>
>The only way I've found (but it's not very easy) is to make a DDS of what I
>want, make the QRY, then make a CPYF to my proper described file, I could
>like if you could have a more easy way.

This seems to be a big gap. I don't know if standard SQL has such a
conversion.

I've heard of a way to accomplish this with DATE functions of SQL (or
Query/400). I'm not sure of the details, perhaps someone else can fill us in.

Good luck

Vernon Hamberg
System Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *