sql server - Sorting on money data type not yielding correct results -

sql server - Sorting on money data type not yielding correct results -

i trying sort results based on column of type money. sorting doesn't seem yield desired results.

query :

select itemid, itemname, total, '$' + replace(convert(varchar,cast(volume money),1), '.00','') volume, '$' + replace(convert(varchar,cast(average money),1), '.00','') average, finaltotal @finaltabvariable order average desc

thanks

bb

there few things see wrong.

you using alias of average name of column want order sorting on varchar value , not money. seek using:

select itemid, itemname, total, '$' + replace(convert(varchar,cast(volume money),1), '.00','') volume, '$' + replace(convert(varchar,cast(average money),1), '.00','') avg, @finaltabvariable order average desc

if average column money, not sure why using cast(average money) in query. seems unnecessary in case.

sql-server money