>>
>>PADL function works with any type. Numeric for sure. That's the beauty of using it instead of transform in some situations...
>
>What type of data transform() doesn't work with? I'm not following you here.
It works with any type too. However, we discussed a problem with transform and trailing zeros few times already. Say, you would need to find a decimal part of the number. I would prefer to use PADL function for certanity.
Anyway, I agree, it's not relevant to the original question...
If it's not broken, fix it until it is.
My Blog