Displaying 0 before a number using number or integer Data type

[astroboy]

I have an integer data type and I would like to display my records that start with 0 as it is. For example, I want my '01' to be displayed as '01', not as 1.

Is there a way to display a '0' before a number using number or integer data type?

[princezuko]

Yes, that's possible. You may try this formula:

CASE
WHEN len([@field:Minutes]) = 1 then '0'+Str([@field:Minutes])
ELSE str([@field:Minutes])
end

[astroboy]

This works but there's a space between the '0' and number. Is there a way to remove the space?

[princezuko]

You may want to try this formula instead:

RIGHT(
    '00' + CAST([@field:FieldName] AS nvarchar(10)),
    2

[SunakoChan]

Hi @astroboy, Just to add you can check the formula on this link: https://howto.caspio.com/function-reference/. And you can check this link to know more about that here: https://www.w3schools.com/sql/func_sqlserver_len.asp