Hi,
I've got a varchar column that I would like to sort padded, to end up with:
30
200
250
Instead of:
200
250
30
Therefore I would use:
REPLICATE('0', ( 10 - LEN(Number) ) ) + Number AS PaddedNumber
In SQL, but I've no clue how to create the DBFunctionCall parameter for this. I can create a nested one, but the combined parameter '10 - LEN(Number)' and the combination of 'REPLICATE (...) + Number' are a mystery to me.
Please help,
Thanks.