Numeric to Text

[#1]

Hi community,

Please i want to transform a field INTEGER to a field STRING in Load statement?

For example : Let take this script.

Ligne:
LOAD CodeLigne,
LibelleLigne,
NumLigne,
CodeSsSousGroupe,
CodeSousGroupe,
CodeGroupe
FROM
Structure_Edition_V02.xls
(biff, embedded labels, table is Ligne$);

The type of field NumLigne is INTEGER,

I want to transform it in STRING.

How to do???

Thanks.

[Miguel_Angel_Baeyens]

Hello Yimen,

Use Text() function. In the following example

Text('000001') AS TextField, Num(000001) AS NumField

TextField will return all preceding zeroes, as the field is considered text, while NumField will return just "1", as preceding zeroes don't count.

Hope that helps