title: return string value from SQL Server tables where column type is integer
body: <p>In my mssql tables i have a clomun that data type is integer. and when i was try thats you know the return value is int.</p>
  
  <pre><code>select h.hekimlik_kod, h.hekim_adi, h.hekim_soyadi, h.il_kod, h.ilce_kod, h.islem_tarihi, h.durum
  h.asm, il.aciklama as il_adi, ilce.aciklama as ilce_adi from hekim as h
  left join il_ilce as il on il.ust_kod = 0 and il.kod = h.il_kod 
  left join il_ilce as ilce on ilce.ust_kod = h.il_kod and ilce.kod = h.ilce_kod
  </code></pre>
  
  <p>int this sql statement "h.durum"' data type is integer. 
  but i want to make thats.
  when h.durum is 0 return string is Yönetici
  when h.durum 1 string is Normal Kullanıcı</p>
  
  <p>how can i do in sql?
  thank you for patience</p>