hello,
Could anyone help me out on the syntax for formating a field in a sql select statment? This is the sql statememt:
select 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