title: SQL Server query is not returning any rows
body: <p>I am trying to read a single column from a single row. After executing the query no rows are returned but there are fields.</p>
  
  <p>When I look at the reader HasRows is false but the field count is 1.</p>
  
  <pre><code>string sql = "select userid from aspnet_Membership where loweredemail = '@email'";
  
  SqlCommand sqlCommand = new SqlCommand(sql, THOGConnection);
  
  string emailAddress = (string)account["ree_thogemail"];
  emailAddress = emailAddress.ToLower();
  sqlCommand.Parameters.AddWithValue("@email", emailAddress);
  
  SqlDataReader reader = sqlCommand.ExecuteReader();
  
  while(reader.Read())
  {
      userId = (Guid)reader["userid"];
  }  
  </code></pre>
  
  <p>If I select all columns in the row then the field count is 21 but there are still no rows.</p>
  
  <p>Why am I not returning any rows?</p>
  
  <p>Thanks, Gary</p>