Try to CONVERT a float to a varchar

[tomr1555]

User wants the word ' hrs' placed at the end of a float variable and I cannot figure out how to do this. WEEK1_cHours is float so I cannot place the hrs onto the amount.

WEEK1_BENEFITDAYS =
CASE WHEN PenAgencyName = 'NIA'
AND WEEK1_SICK > PenSickWeeksPd THEN 0
WHEN PenAgencyName = 'NIA'
AND WEEK1_OJI > PenOJIWeeksPd THEN 0
WHEN EMP_STATUS_1 = '39'
AND HWAgencyName IN ( ' CS' )
AND WEEK1_cHours < 24
THEN WEEK1_cHours
WHEN EMP_STATUS_1 = '02'
AND HWAgencyName IN ( ' CS' )
AND wrpTransfer.UNION_LOCAL <> ''
AND WEEK1_cHours < 24 THEN WEEK1_cHours
ELSE WEEK1_cUnits + WEEK1_pUnits END,

Any help would be appreciated.

 

[MarkSweetland]

WEEK1_BENEFITDAYS = [red]convert(varchar,[/red] 
	CASE 
	WHEN PenAgencyName = 'NIA' AND WEEK1_SICK > PenSickWeeksPd THEN 0
	WHEN PenAgencyName = 'NIA' AND WEEK1_OJI > PenOJIWeeksPd THEN 0
	WHEN EMP_STATUS_1 = '39' AND HWAgencyName IN ( ' CS' ) AND WEEK1_cHours < 24 THEN WEEK1_cHours
	WHEN EMP_STATUS_1 = '02' AND HWAgencyName IN ( ' CS' ) AND wrpTransfer.UNION_LOCAL <> '' AND WEEK1_cHours < 24 THEN WEEK1_cHours 
ELSE WEEK1_cUnits + WEEK1_pUnits END[red]) + ' hrs'[/red],

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[tomr1555]

Thanks Mark..

Only the two statements listed below need the hrs added to the amt.

WHEN EMP_STATUS_1 = '39' AND HWAgencyName IN ( ' CS' ) AND WEEK1_cHours < 24 THEN WEEK1_cHours

WHEN EMP_STATUS_1 = '02' AND HWAgencyName IN ( ' CS' ) AND wrpTransfer.UNION_LOCAL <> '' AND WEEK1_cHours < 24 THEN WEEK1_cHours

 

[MarkSweetland]

The convert statement will convert the final computation of all your case logic. WEEK1_BENEFITDAYS can only equal one value, regardless of the number of case when-then-else clauses. That value will be converted to a string with ' hrs' appended.


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach