how to modify this codes?

[Anonymous]

Hello,

i have a column "Indice brut " which represents codes like('121','546'...).

i want to change the format of this codes from 3 to 4 characters.

Hw could I do this ?

[sunny_talwar]

May be this

Num([Indice brut], '0000') as [Indice brut]

[jyothish8807]

Hi Zouhour,

Refer the attached;

I thought your value is in ('121','546'...) format.

Br,

KC

[Anil_Babu_Samineni]

What purpose you want to add one more character? Can you define output?