Search the Insulator Patent Reference Library

SELECT DISTINCT patent.*, YEAR(date) as year FROM patent WHERE (category = 'Pin') ORDER BY patent ASC, type

Search error: Table 'reference.patent' doesn't exist

SQL: SELECT DISTINCT patent.*, YEAR(date) as year FROM patent WHERE (category = 'Pin') ORDER BY patent ASC, type

Total of 0.00 seconds

Build your search criteria. The patent must match all the values specified.
Select patent types:	Utility Design Reissue
Patent number:
Date:
Year between:	and
Patentee starting with:
City:
State:
Assigned To starting with:
Description containing:
Category:
Class:	Subclass:
Click Search when complete: