Thanks for the info.
Qlikview is setup to first pull all data to QVD files and the projects themselves load data from these files.
I was trying with text() in the file that creates the QVD files but that gave errors in SQL.
When I would use text() when I pulled data from the QVD file it didn't change anything. And I didn't know how to force this in SQL.
Now I used the Num() function. T3FIRM & T3TXRT & NUM(T3TXNR, '000')
i'm not sure if it is 100% correct but I couldn't find an error in the list.
thank you all for your help.
Did you get an answer to this problem? We are having a similar issue whereby we pull data to QVD files and the data is then loaded from these files to the projects. Some of the data is losing the leading zeros but not all.
We have tried forcing it from SQL using CAST and also TEXT when loading into the project but without success.
Any help would be much appreciated.