In article <20050711121440.8127.qmail@...>, Max Thorne wrote:

> how can I prevent a user from inserting duplicates in a table? For example I have table "company" with field "name" and a unique index for this field. However, a user can insert values like "Diesel Co.","DIESEL CO.", "diesel co.". Same company, different entries. Thanks!
>

Have a duplicate field, populated by trigger, that holds a case-insensitive
copy of the name, place a unique index on that field as well.

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly