>>What exactly do you mean here?
>
>A word to the wise. :)
>
>In TRANSFORM we can format the data.
>
>@C Appends CR to positive Currency or Numeric values to indicate a credit.
>
>@X Appends DB to negative currency or numeric values to indicate a debit.
>
>I want DB to be DR which is standard for Debit at least in accounting books.
>How can i achieve this in VFP?
? CHRTRAN(TRANSFORM(-1231,[@X]),[B],[T])
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.