Added zeros to field

[dimak123]

Hi to all

Need help, somehow i am getting field on layout different from original data.

How can i show the exact field?

[#2]

try it once in  text object

by using same expression

=len(INVENCOLORID)

[dimak123]

[Gysbert_Wassenaar]

Try num(Field, '0000')

[tamilarasu]

Hi Dima,

Paste the code above the sql statement.

Load *,

Num(Field) as New;

[dimak123]

Num' is not a recognized built-in function name.

[dimak123]

SQL##f - SqlState: 37000, ErrorCode: 195, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]'Num' is not a recognized built-in function name.

SQL SELECT

    len(INVENTCOLORID) as Length,

    INVENTCOLORID as Field,

    Num(INVENTCOLORID) as New

FROM

[raghvendrasingh]

Try this:

Tab1:

SQL SELECT

      len(INVENTCOLORID) as length,

     INVENTCOLORID as Field

from "DNA_PROD".dbo.NAOTMOBILEITEMS;

noconcatenate

Tab2:

Load length,

     text(Field) as Field

resident Tab1;

Drop tab Tab1;

[jonathandienst · Accepted solution]

Do you want to preserve the exact number of leading zeroes? Then do this:

LOAD text(Field) As Field,

     Length;

SQL SELECT

     Len(..... rest of your SQL expression ....

;

[dimak123]

still the same