RE: SQL cast(Num1as char(5))

That works.  Thanks.

I added a substr() function to scale in down to 5 char long.  
substr(DIGITS(num1), 2, 5)



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of CWilt@xxxxxxxxxxxx
Sent: Thursday, May 20, 2004 9:04 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: SQL cast(Num1as char(5))


Yes,

Use DIGITS(num1)

Instead of CAST()

Charles


> -----Original Message-----
> From: Lim Hock-Chai [mailto:Lim.Hock-Chai@xxxxxxxx]
> Sent: Thursday, May 20, 2004 10:01 AM
> To: Midrange Systems Technical Discussion
> Subject: SQL cast(Num1as char(5))
> 
> 
> Is there a way to keep the leading zeros when casting a 
> numeric field to char?
> Example:
>     If Num1 has a value of 23, I would like the casted result 
> to be 00023.
>  
> thanks
> _______________________________________________
> 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.
> 
_______________________________________________
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.