Como usar IN e LIKE com SqlCommand + Parameters ao fazer uma consulta SQL

using (SqlConnection Conn = new SqlConnection(ConnectionString))
{
	//DELETE FROM tblUsuarios WHERE id IN(1,2,3)
	string sSQL = "exec('DELETE FROM usuarios WHERE id IN('+@ids+')')";
	SqlCommand cmd = new SqlCommand(sSQL, Conn);
	cmd.Parameters.AddWithValue("@ids", "1,2,3");
	Conn.Open();
	cmd.ExecuteNonQuery();
	Conn.Close();

}

using (SqlConnection Conn = new SqlConnection(ConnectionString))
{
	//SELECT * FROM usuarios WHERE nome LIKE '%fulano%'
	string sSQL = "SELECT * FROM usuarios WHERE nome LIKE @nome";
	SqlCommand cmd = new SqlCommand(sSQL, Conn);
	cmd.Parameters.AddWithValue("@nome", "%fulano%");
	Conn.Open();
	SqlDataReader dr = cmd.ExecuteReader();
	while (dr.Read())
	{
		Response.Write(dr["nome"] + "<br />");
	}
	Conn.Close();
}