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.
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.