Depends. If your Hour and Rate columns are text based, than the first thing you want to do is to replace them with number values. It make sit a lot, lot easier to do math, because you don't have to convert them to numbers each time you use them, with the inherent error checking that that involves. So assuming you have gone for numeric fields:
SELECT '$' + CONVERT(VARCHAR(10), Hour * Rate) FROM MyTable