title: concatenate a zero onto sql server select value shows 4 digits still and not 5
body: <p>I have zip codes that on import didn't have zero from excel file.  So I was doing a select in order to concatenate 0 to front of every 4 digit zip code.</p>
  
  <p>I was trying this,  but it still spits out 4 digits</p>
  
  <pre><code>   (0 + [ZIP]) as 'fullzip'
  </code></pre>
  
  <p>ZIP is a float in db table</p>
  
  <p>my full sql </p>
  
  <pre><code>SELECT
      TOP 1000
     [ZIP]
    ,(0 + [ZIP]) as 'fullzip'
    ,[ZIP_Name]
    ,[ZIP_CountyFIPS]
    ,[ZIP_County]
    ,[ZIP_State]
    ,[Utility_Name]
    ,[Holding_Company]
    ,[Utility_ID]
    ,[GAS_LDC_Type]
    ,[ELEC_Non_IOU_Type]
    ,[Percent_of_Overlap]
    ,[Utility_Territory_Type]
  FROM
      cc.dbo.ServiceableZipCodes
  WHERE
      Len( [ZIP] ) = 4
  </code></pre>