• 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