C#连接SQL语句问题

select r.BedNum,r.Roomid,r.Description,t.TypeName,s.RoomStateName
from Room r
inner join RoomType t on t.TypeId=r.RoomTypeId
inner join RoomState s on s.RoomStateId=r.RoomStateId
where r.Roomid like %@name%
SqlParameter[] para ={
new SqlParameter("@name",name)
};
怎么才能使用模糊查询？不管有没有值都能查询到内容，求大神

string strConn = @"data source=.;initial catalog=Northwind;integrated security=true;";
            SqlConnection conn = new SqlConnection(strConn);

            //关键
            string sql = @"select * from employees where FirstName like @FirstName";
            string fn = "%" + "ae" + "%";
            SqlParameter p = new SqlParameter("@FirstName", fn);

            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.Parameters.Add(p);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            dataGridView1.DataSource = dt;