That is good to know the next time I want to:
A.) Convert an interger to a varchar then
B.) Convert that varchar to a smaller varchar then
C.) Cast said varchar as a float then
D.) Store float as an integer then
E.) Select the output for use somewhere else...
DECLARE @C INT,@d INT
SET @C = 211
SET @d = CAST(CONVERT(VARCHAR(2),CONVERT(VARCHAR(3),@c)) as FLOAT) * 0.5
SELECT @d