RE: Another dumb SQL newbie question, this time about CASTing types

Select digits(mynumber) from........


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Lampert
Sent: Wednesday, April 27, 2011 4:22 PM
To: Midrange Systems Technical Discussion
Subject: Another dumb SQL newbie question, this time about CASTing types

As I recall, the last time I used a CAST statement, it didn't preserve
leading zeroes.

I need to CAST a 5-digit Zoned Decimal number to a character string, as
a parameter to a UDF, called in the Select that defines a view, such
that leading zeroes are preserved. i.e.,

1001 becomes '01001'
11001 becomes '11001'
and so forth.

What's the easiest way to do this?