still have no idea what you are talking about. In your table what data type is Amount.
declare @shootout table(Name nvarchar(50), Amount varchar(50) )
insert into @shootout
select 'Jon', '1,000,000.00' union
select 'Greg', '8,000.00'
select header
from
(
select '|Name|Amount|' as header, -1 wizwaz union
select '|' + Name + '|' + Amount + '|', 999
from @shootout
) a
order by wizwaz