Re: sql help

[cybershot]

this query added the dollar sign to the money

SELECT ‘$’ + CONVERT(CHAR(5), cost, 0)
FROM PART;

I had to convert the results of the cost column and the zero means to add two decimal places. This is what the query returned

$0.59
$0.66
$5.77
$6.12
$0.88
$0.94
$0.74
$2.09
$1.87
$1.96
$3.55
$3.65
$3.58