title: What would be a reliable way to get fractional value from a number?
body: <p>I have a number of type <code>Decimal(8, 2)</code> and have been using <code>Substring</code> to get fractional value.</p>
  
  <pre><code>E.g.)
      declare @val decimal(8, 2), @strVal varchar(10)
      set @val = 15.80
      set @strVal = cast(@val as varchar)
      select  @val, substring(@strVal, charindex('.', @strVal), len(@strVal))
  </code></pre>
  
  <p><strong>Is there a better way to simply get fractional value, <code>.80</code> from <code>@val</code> without having to convert it to a character?</strong> <br />
  I am wondering if there is a built-in UDF (User-Defined Function) that would parse instead of having to rolling out my own version.</p>