Conver number to String!
Hi all,
Plz see:
SELECT T0.[Account], T0.[Debit], T0.[Credit], T0.[TransId], T0.[LineMemo],T0.Line_ID,T0.[RefDate], T1.[Comments] ,T1.convertCurrency FROM ORCT T1 , JDT1 T0 WHERE T0.[TransId]= T1.[TransId] and T0.[ContraAct] ='1111' and T0.Credit0
Note: T1.convertCurrency is a field, i created in ORCT table
For example: T0.Debit = 1.200.000 VND
i want to convert T1.convertCurrency = one million two hundreds thousand vietnam dong
but I want it to convert to vietnamese language, but not english language
what can i do?
Rgds!