I have a database of printers and their attributes. There are duplicate printer names in the DB, where the name is the same but the capitalization is different and the attributes of the two listings are different.<BR><BR>I have a page that add's a printer to the DB. However, if there is already a printer in the DB with that name (but different capitalization) the confirmation page returns that one.<BR><BR>I use this statement to insert the new printer into the DB:<BR>"INSERT INTO PRINTERTYPES (PRINTERNAME) VALUES ('" & printer & "')"<BR><BR>And I use this statement to query the database for the new printer and get it's ID number so I can display the printer in the confirmation page:<BR>"SELECT printername, id FROM printertypes WHERE printername = '" & printer & "'"<BR><BR>These two statements are on the same page and the variable "printer" doesn't change values. <BR><BR>Does anyone know why the SELECT statement returns the wrong record???