Re: Logical File with Field being substringed as a Key

Look at it from the other way around.  Instead of trying to 
move the fallen oak tree from your leg, dig out some dirt from 
under your leg.

In other words, make the other field string.  For example.
Select * from filea where substr(field1,1,3) = digits(OfSomeNumericField)

digits converts into string.





dpanco43@ix.netcom.com on 03/24/2000 03:14:33 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Re: Logical File with Field being substringed as a Key

When using a logical files substring function, is there anyway to further
define that substringed portion as numeric.  We have a situation where we
sometimes want to pick some information out of a character field and use it
as input into a sequel.  We then often want to do calculations on that
information.  If we could use the logical to redefine the alpha data as
numeric, that would help immensely.

Debbie

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---