Finally got it! I'm not sure if this is the best way, but it worked for me:

select CONVERT(NUMERIC(3,0),(CONVERT(int,SUBSTRING(Col4,1,CHARINDEX('%',Col4)-1))))/100

FROM Executive.StagedimWeight

WHERE Col4 IS NOT NULL

AND Col4 LIKE '%\%%'ESCAPE '\'