Create a Customerid from a code

[ecabanas]

Hi I have the following customerid:

1

2

3

12

100

and I would like to transform in "C000000" patern

C000001

C000002

C000003

C000012

C000100

I think it's easy but I am in a loop and blocked

Many thank's

Eduard

[Clever_Anjos · Accepted solution]

LOAD

'C' & NUM(yourfield,'000000') as  yournewfield

from yourqvd.qvd(qvd)

[Clever_Anjos]

Or even simpler

num(yourfield,'C000000')