Hi all,

I need your expert helps. I would like to know how to retrieve text data field like order text (tsmsc100.txta) directly from Oracle database through SQL query? This column tsmsc100.txta will only return the numeric data instead of texts.

Do you know where the texts store at and which table to go?


Best Regards,
Grace

The texts are stored in tttxt010 for that company. It is stored with a line number, you can check out the table.

Thanks your help, Marks.

Best Regards,
Grace :)