You can use NTOM() function.
>hello,
> Could anyone help me out on the syntax for formating a field in a sql select statment? This is the sql statememt:

*--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.
>sherry