Dear Friends, Can anybody tell me how can i check the value for the primary key column. Let me tell u more specific. i have a table called books, columns: name(primary key), price are the columns of the table. one record values(&#039asp&#039,400) is there. so now one person entering through asp(on web)another record. if the person enters &#039asp&#039 as a book again where,how can catch it. do i need to select all records and check all the records whether it is there or not.sql will through exception but in asp how can i hadle that..?<BR>any help is appreciated.<BR>Thanks in Advance. "" .