title: How to convert an EBCDIC zoned decimal to a decimal in MS SQL Server 2014?
body: <p>Hi everyone this is major chunk for me I have been trying lot but not getting success <br>
  there is data in db as [AH_TRAN_CV] of length 9 as Integer. and I want that in varchar with 9 char and 2 decimals. <br>
  <br>I guess this whole code may be wrong as I don't have knowledge just used internet to get till here.. The sample is like <pre>
  123D is +1234
  678{ is +6780
  468K is -4682
  Digit Positive Negative 
  0         {        }
  1         A        J
  2         B        K
  3         C        L
  4         D        M
  5         E        N
  6         F        O
  7         G        P
  8         H        Q
  9         I        R
  </pre>
    So kindly help. Below is just part of code<br>
  Code :</p>
  
  <pre><code>Case When (substring(convert(varchar,[AH_TRAN_CV] * 0.0000001), 9, 1)  = '4' 
        and ([AH_TRAN_CV] &gt;= 0.00)) 
          Then concat (substring(convert(varchar,[AH_TRAN_CV]*0.0000001), 3, 8), 'D')
  end [AH_TRAN_CV]
  </code></pre>