I am pretty srue there is a proper conversion however I cannot seem to find it right off. But here is a way that will work

DECLARE @S as VARCHAR(2)

SET @S = '4F'

EXEC('SELECT ASCII(CAST(0x' + @S + ' as varbinary(1)))')