The following is a select statement from my asp page. I no longer want to query for the birthdate/varbirthdate part (but I still want to query for the color/varcolor part). These quote rules are a little confusing, can someone tell me how to rewrite it? I just want to make sure it is correct. I am in a hurry and just need to do it quickly so I just thought I would ask. By the way, the color is in the format of text in the database. Thank you very much!<BR><BR>objCommand.CommandText = "SELECT name FROM fishtable Where color = '" & varColor & "' AND birthdate = '" & varbirthdate & "'"