Subject: Re: sorting the result of a calculation on xml that can have missing/blank tags
From: Ragulf Pickaxe <ragulf.pickaxe@xxxxxxxxx>
Date: Wed, 14 Dec 2005 13:32:24 +0100
|
Michael Kay wrote:
> However, to get a default value of "0",
>
> number(concat('0', string(HomePupils)))
>
> works in both cases.
Ah! Much smarter than my solution. Of course a leading zero does not
change the number.
It is always a joy, when I see such clear and concise solutions, which
this list provide in abundance.
Ragulf :-)
|
Cart
