*--sb-- added NTOM() function to convert Total column to Currency >select NTOM(sum(iif(test > 0, test,0))) as total ; > from dummy ; > where id = > 0; > into cursor temp>I want to format the field "total" in a currency format. What is the syntax for that?? thanks.