Re: AW: Putting Leading Zeros in Sql ?

Birgitta,

Thanks.

I tried my suggestion at work, but came out with the same results you 
described. did not think of using the functions DECIMAL or ZONED.

I was looking for an alternative to prevent using the CASE-statement, as I 
think it is difficult to understand at times. This solution, with nested 
functions, is not the best, either, but would have my preference.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 27-6-05 at 12:24 Hauser, Birgitta wrote:

>Hi Carel,
>
>>>Would not the following statement do the same?
> 
>>>CHAR(DIGITS(MONTH(CURRENT DATE)), 2)
> 
>The result of your statement will always be '00', because Month() returns an 
>integer value.
>If you convert an integer with digits the result consists of 10 characters. 
>Char takes the first 2 characters.
>But the following statement will return the correct month:
> 
>DIGITS(DEC(MONTH(CURRENT DATE), 2, 0))