title: Get only decimal part in float number in SQL Server
body: <p>I have following number  in SQL Server 2008 : 5.4564556<br>
  I just want to get only 4564556 from 5.4564556<br>
  it would be better if i can get only 4 among 4564556 that is first digit of fractional part..</p>
  
  <p>How can i do it?</p>
  
  <p>Thanks</p>