title: How Can I Split Decimal Value from Integer Value?
body: <p>Assume i have 4.9 value.</p>
  
  <p>I would like to split 4 and .9 ... How can i do it?</p>
  
  <p>I could isolate 4 by using FLOOR(). What about the .9? How can i isolate it?</p>
  
  <p>I'm using t-sql sql server 2005/2008</p>