database values ​​do not coincide with qlikview values

[#1]

Hello

I have a field (id_Personal) with values ​​08, 06, 03 to pass to qlikview I get 8,006,003.

Use the following syntax:
OLEDB CONNECT TO [Provider = SQLOLEDB.1; Persist Security Info = True; User ID = qlikview; Initial Catalog = Storage, Data Source = melodepo; Use Procedure for Prepare = 1; Auto Translate = True; Packet Size = 4096; Workstation ID = SRVQLIKVIEW; Use Encryption for Data = False; Tag with column collation When possible = False] (XPassword is OKNSdQRMNLaADbEGQRPB);

LOAD "Id_Compania"
     "Fecha_Transaccion", "Id_Personal"
     EmpCod;
SQL SELECT *
FROM Deposito.dbo. "Historico_Movimiento_Encab"
Where year (Fecha_Transaccion)> = 2013;

how to make passes exactly the same values​​.

Please help,

Rolando

[Clever_Anjos]

Maybe you need trim values, so use this

LOAD "Id_Compania"

     "Fecha_Transaccion",

     num(trim("Id_Personal"),'00') as Id_Personal, // Or 000 if you want 3 digits

     EmpCod;

SQL SELECT *

FROM Deposito.dbo. "Historico_Movimiento_Encab"

Where year (Fecha_Transaccion)> = 2013;

[#3]

After doing tests with the recommendations, I still have the same problem described:

the field in the database is 3 digits, may have id_personal with 2 or 3 digits, for example:

Table Historico_Encab(database)      Qlikview      Tabla_Personal(database)

Id_Personal: 08                                    008                08

                     06                                    006                06

are not equal: qlikview(Tabla historico_Encab) and tabla_personal:

Helpme please

[#4]

thank you all for the cooperation