title: Converting kilograms to grams in SQL query in SSMS
body: <p>In the following code there is a column name called <code>birthweight</code>, presently in the table where it is pulling form is displayed in 'kg', but I want it to be displayed in grams by converting kg to g</p>
  
  <p>For example right now it shows 2.92 kg and I need to convert it to 2920.00 g</p>