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.

REPLICATE('0', ( 10 - LEN(Number) ) ) + Number AS PaddedNumber

Try this please:

new DbFunctionCall(
    "REPLICATE ('0', ( 10 - LEN({0}) ) ) + {0}  AS PaddedNumber", new object[] { MyEnitityFields.Number});

(Edit) Or

new DbFunctionCall(
    "REPLICATE ('0', ( 10 - LEN({0}) ) ) + {0}", new object[] { MyEnitityFields.Number});