Convert curency!

[Former Member]

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!

[Former Member · Accepted solution]

Hi,

Please refer to this link, [Click Here|http://www.crystalkeen.com/articles/crystalreports/currencyaswords.htm]

Regards,

Clint