title: Convert lb and oz to grams - SQL Server
body: <p>I have a column for weight in lb and oz together </p>
  
  <p>For example we have data like this in the column:</p>
  
  <pre><code>8 lb 8.863 oz
  6900 lb 7.495 oz
  </code></pre>
  
  <p>Can someone help me to convert the <code>lb+oz</code> together to grams?</p>
  
  <pre><code>Birthweight = Visit.WeightField -- (TableName.FieldName)
  </code></pre>
  
  <p>I new we need to multiply by 454 but it doesn't work.</p>
  
  <p>Please help me in change the above Weightfield column in SQL line.</p>
  
  <p>For example conversion of kgs to grams is as follows </p>
  
  <pre><code>  BirthWeight= ISnull(cast((cast(rtrim(replace(Visit.WeightField,'kg','')) as float) * 1000) as varchar(max)),'0')
  </code></pre>