Re: SQL string conversion

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

Mark

At 10:01 AM 1/28/98, you wrote:
> Is there a way to convert a string to a numeric in SQL/400?  I have a file
>that is being uploaded from a PC.  The initial DB that it is being uploaded
>to has a single field.  The area in the record is being pre-screened to
>make sure it is numeric.
>
> What I wanted to do is something like this:  SELECT * WHERE VAL( SUBST(
>DATA, 15, 7 ) ) > 100.  Or assign it to a numeric field an on update.  I
>realize that there is no VAL function.  Is there an equivalent function or
>workaround?


Here's something from a previous post of mine:

>Checked with Support Line and got the following solution:
>
>       microsecond(timestamp('1996-01-01-00.00.00.' || datchr))
>
>where datchr is a 6-position character field.
>
>This method is limited to 6 digits. Less than 6 would require padding the
character string with leading zeroes. More than 6 would require
substringing into 6-position segments and multiplication by 1,000,000, etc.
>

HTH

Vernon Hamberg
Systems 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 MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---