Skip to Content
0
Former Member
Mar 10, 2009 at 01:19 AM

Convert curency!

34 Views

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!