Sql Server 2008，将十进制值转换为percentaje而不进行舍入？(Sql Server 2008, Convert decimal value to percentaje withouth rounding?)

 如何在没有舍入值的情况下将数字0.967741935483870967742转换为％96.77？ 
 
 到目前为止我有 
 
SELECT 
     VAL1 = '%' + convert(varchar, CONVERT(DECIMAL(10,2), 0.967741935483870967742 * 100 )
FROM my_table
 
 这给了我％97.00; 
 
 编辑：我尝试这样做没有任何成功： 
 
SELECT 
     VAL1 = '%' + convert(varchar, CONVERT(DECIMAL(10,2), 0.967741935483870967742 * CONVERT(DECIMAL(10,2), 100) )
FROM my_table

How Can I conver the number 0.967741935483870967742 to %96.77 without rounding values?
 
So far I have
 
SELECT 
     VAL1 = '%' + convert(varchar, CONVERT(DECIMAL(10,2), 0.967741935483870967742 * 100 )
FROM my_table
 
wich gives me %97.00;
 
Edit: I tried doing this without any success:
 
SELECT 
     VAL1 = '%' + convert(varchar, CONVERT(DECIMAL(10,2), 0.967741935483870967742 * CONVERT(DECIMAL(10,2), 100) )
FROM my_table

原文：https://stackoverflow.com/questions/19868046