Convertir texto a numero

[#1]

Estimados, tengo este problema, como puedo convertir a numero un dato de 15 digitos, por ejemplo

000000000125481  a  125481

000000012601511  a  12601511

000000000001225  a  1225

tengo 2 tablas que se unen por este codigo, o tambien como hacer para que se complete con CEROS

125481  a   000000000125481

Gracias por el apoyo.

[swuehl]

My spanish is not very good, but maybe one of these will help you to either strip the zeros or format your numbers with leading zeros:

Number1:

LOAD num(Number) as Number1 INLINE [

Number

00000012123214

12000123000122

00001232134414

];

Number2:

LOAD num(Number,'000000000000000') as Number2 INLINE [

Number

123456

244

45353535

];

[Clever_Anjos]

SET Ceros = 15;

LOAD

          right(Repeat('0',$(Ceros)-1)  & RecNo(),$(Ceros))  as x

AutoGenerate 200;

[#4]

Thanks, i worked the first, i have problems with the NUM, and the second came out perfect.

I found this here:

replace(ltrim(replace(CAMPO1,'0',' ',)),' ',0) as CAMPO1

Thanks for the help.

[#5]

Hello , to complete with ceros to the left i did this sentence:

set var=10;

repeat('0', var - len(campo)) & campo;