problem with alpahnumeric field that containes a dot on the right

[wizardo]

Hi,

I am pulling data from an sql server (tried with oledb and odbc)

in a table in the sql i have a field that is defined as alphanumeric

it contain's alphanumeric values that should be read as text

when i load them into QlikView it convert some of the values to number incorrectly

E.G

I have a field with 2 values

"109"

109."  //notice the dot

qlikview convert them both into numeric values as "109" // without the dot

I have tried using the the text function but it does not help

I have tried changing the numberformat decimal sign to something other then a dot and even to an empty string but it doesn't help

this field is a linking field and this makes my whole model unusable

hope someone can help

Mansyno

[#2]

LOAD Text(value) as exe;

LOAD * INLINE [

    value

    5

    6.

    006

];

[er_mohit]

hiiii

see the attached file