then try this one if u want to use *--

create procedure startrred

@hourstarted varchar(10)

as

begin

if(@hourstarted!='*')

begin

Select *

from Production where hourworked>@hourstarted

END

else

begin

select * from Production where hourworked>15

end

end