Qlikview-SAP SQL Select Load statement issue

[Kirti007]

Hi,

I am using following query: It gives me weird result.  SQL load is not considering 'E' at the end of the customer string.

please help me find solution. I know this is happening because 0000037004 is getting loaded first and while loading 37004E, Qlikview considers it as same integer as previouly loaded.

When I load all records from customer table, I see 2 records as per below image.

ABC:
SQL Select
*
from CUSTOMER
Where CUSTOMER = '0000037004' or
CUSTOMER = '37004E'
;

Result:

[Brett_Bleess]

Kirti, I believe the correct solution on this one is to add Load statement in front of your SQL Select and use the Text() function on that field, that will ensure the leading zeros are maintained I believe.  

So something like...

ABC:

Load Text(CUSTOMER) AS CUSTOMERTEXT...

SQL Select *...

Regards,
Brett