<div>
That worked. &nbsp;NOW .. &nbsp;how can I join the tables &nbsp;I tried: &nbsp; 
(AVO.HeightInFeet + '/ ' + CONVERT(int,AVO.HeightInInches)) as Height but that didn't work. &nbsp;Same for Wt. &nbsp;I tried to join. &nbsp; 
(CONVERT(INT,AVO.WeightInPounds) + '-' + CONVERT (Int,AVO.WeightInOunces)) AS 'Weight' 
But this did not work. 
 
KR
</div>

<div>
This is what I had as my final script: 
 
(cast(AVO.HeightInFeet as varchar) + ' ft/ ' + cast(CONVERT(int,AVO.HeightInInches) as varchar) + ' in ' ) AS 'Height', 
(cast(CONVERT(INT,AVO.WeightInPounds) as varchar) + '.' + cast(CONVERT(Int,AVO.WeightInOunces) as varchar) + ' lbs')AS &nbsp;'Weight', 
 
This produced results which read: 
 
HEIGHT &nbsp; &nbsp; &nbsp; &nbsp;WEIGHT 
5ft/7in &nbsp; &nbsp; &nbsp; &nbsp; 150.0 lbs 
 
KR 
Thanks for all your help
</div>

<div>
<div class="content wysiwyg-content">
I have a report that lists a patient Height and weight as the following: 
 
HeightInFeet &nbsp; &nbsp; &nbsp;HeightInInches &nbsp; &nbsp; &nbsp;WeightinPounds &nbsp;Weight in Ounces 
&nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10.0000000 &nbsp; &nbsp; &nbsp; &nbsp;156.0000000 &nbsp; &nbsp; &nbsp; &nbsp; 6.4000000 
 
I converted the inches as : &nbsp;CONVERT(decimal(2,0),AVO.HeightInInches,101) as 'Inches', 
I converted the Pounds as: &nbsp;CONVERT (Decimal(3,0),AVO.WeightInPounds,101) as 'Pounds', 
and I converted the ounces as: &nbsp;CONVERT (DECIMAL(2,0),AVO.WeightInOunces,101) AS 'Ounces' 
 
The Inches and ounces come out correctly but the Pounds does not, &nbsp;Can you see what I am doing wrong, 
 
I would like it to read: &nbsp; 
HeightIn Feet &nbsp; HeightInInches &nbsp; &nbsp; &nbsp;WeightinPounds &nbsp;Weight in Ounces 
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;156 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6.4 
 
KR
</div>
</div>

I have a report that lists a patient Height and weight as the following:

HeightInFeet      HeightInInches      WeightinPounds  Weight in Ounces
      5                       10.0000000        156.0000000         6.4000000

I converted the inches as :  CONVERT(decimal(2,0),AVO.HeightInInches,101) as 'Inches',
I converted the Pounds as:  CONVERT (Decimal(3,0),AVO.WeightInPounds,101) as 'Pounds',
and I converted the ounces as:  CONVERT (DECIMAL(2,0),AVO.WeightInOunces,101) AS 'Ounces'

The Inches and ounces come out correctly but the Pounds does not,  Can you see what I am doing wrong,

I would like it to read:  
HeightIn Feet   HeightInInches      WeightinPounds  Weight in Ounces
5                          10                            156                         6.4

KR

How to convert ounces

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.