StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from UserMailDB ");
strSql.Append(" where Users like '%,'+@accountName+',%' ");
SqlParameter[] parameters = {
new SqlParameter("@accountName", SqlDbType.NVarChar) };
parameters[0].Value = accountName;
UserMailDB model = new UserMailDB();
DataSet ds = SqlHelper.ExecuteDataset(sqlconnection, CommandType.Text, strSql.ToString(), parameters);
*注意:.net中拼接sql like语句,特别注意单引号双引号的位置