You can use format if you are an extremely patient person.
Normally for presentation issues,  you want to handle that on the front end, in the application or report. In SQL Server, you can cast it to an int and then to a varchar so you can  add the percent sign.
SELECT CAST(CAST(OP_Percentage * 100 as int) as varchar(10)) + '%'

Sue