I have a sum in my sql statement select sum(service.price) as total and sum(service.price) *.10 as savings To give a 10% discount
when i write response.write rs("total") or rs("savings") the right info displays
But i need to subtract savings from total. how would this be written
i.e. response.write rs("savings - total")