title: Converting a number to feet & inches
body: <p>I want to take a number from a table ( using sql server 2008 ) such as 720 and convert it to feet and inches  with this: </p>
  
  <pre><code>Format(Val(Length) \ 12, "00' ") &amp; Format(Val(Length) Mod 12, "00\""")
  </code></pre>
  
  <p>This should be in a sql statement.</p>
  
  <p>I'm having trouble getting the syntax correct. Any help please?</p>