how convert number field to text

[#1]

The invoice_num field in Oracle Financials is text (the data is alpha/numeric) but when the field is in Qlikview it is showing it as a number. I have put in script TEXT(Invoice_Num) but this has made no difference, any ideas how to get it as text? The field is in a table that is extracted into a QVW and this is reloaded once a day. The QVW just says the table name and all fields are extracted for the table.

[Gysbert_Wassenaar]

Using the text function is the way to make text from numbers. Are you sure Qlikview makes numbers from them? Can you post a document that demonstrates the problem?

[martyn_birzys]

That's sound right as above, text() is the one to use.

If it is alpha-numeric, how are non-numeric characters displayed? Could you post screenshot?

Experiment with string operations to assure it comes across as string, eg:

'A' & Invoice_Num as Invoice_Num_Test