If I was going to use the STUFF I would want to make sure the field was always the same length.  And since I may not always be able to...

SELECT original_value,
    CAST(ROUND(CONVERT(INT, original_value) / 10.0, 0) AS DECIMAL(9, 3)) AS decimalvalue
FROM (VALUES('0054880'), ('0054885'), ('02120'), ('00002124'), ('2125')) x(original_value)
;

Results:
original_value    decimalvalue
0054880     ...

Just to see how bad I get pounded for this code. This will give you any 'A' claim types where you don't have a 'P' or all 'P' that don't...

I can't believe the number of people hung up on February not always having the same last day.  Some simple SQL with get the correct date for you.
Not everyone...

I just don't get it.  Why if there is a field that will only contain the EOM date would I want to use that logic?
Why do this:
Where DateField...

This should have been:
" I would though guess that half the developers at my current shop and more than half at my prior shop wouldn't understand or follow the tally...