SQL语句查询数字各个位上的值

问题：实际问题：做报表的时候，银行借据上要显示数额的各个位上的值。(如下图)：

        

 解决方案：1.SQL语句查询的时候根据金额计算

                 2. 在做报表的时候在根据金额计算

不会玩SQL Server Data Tools，最终决定用在SQL里面计算。

 

SQL语句: （其实不难，主要是花了不少时间，自己Mark一下,默认借款金额不会过亿）

select AMOUNT,
    case when AMOUNT >= 10000000 then CAST(cast(AMOUNT/10000000 as int) AS VARCHAR)
         else '' END AS 千万,
    case when AMOUNT >= 1000000 THEN CAST(cast((AMOUNT%10000000)/1000000 as int) AS VARCHAR)
        else '' END AS 百万,
    case when AMOUNT >= 100000 THEN CAST(cast((AMOUNT%1000000)/100000 as int) AS VARCHAR)
        else '' END AS 十万,
    case when AMOUNT >= 10000 THEN CAST(cast((AMOUNT%100000)/10000 as int) AS VARCHAR)
        else '' END AS 万,
    case when AMOUNT >= 1000 THEN CAST(cast((AMOUNT%10000)/1000 as int) as VARCHAR)
        else '' END AS 千,
    case when AMOUNT >= 100 THEN cast(cast((AMOUNT%1000)/100 as int) as varchar)
        else '' end AS 百,
    case when AMOUNT >=10  THEN cast(cast((AMOUNT%100)/10 as int)AS VARCHAR)
      else '' end AS 十,
    case when AMOUNT >= 1 THEN cast(cast(AMOUNT%10 as int) as VARCHAR)
     else '' end AS 元,
    case when AMOUNT * 10 > 1 THEN cast(cast(AMOUNT*10%10 as int) as VARCHAR)
    else '' end AS 角,
    case when AMOUNT * 100 > 1 THEN cast(cast(AMOUNT*100%10 as int) as VARCHAR)
    else '' end AS 分
 from [tabName]