Max Thorne wrote:

>
> Hi,
>
> 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!
>
> Max

Hi Max,

put a new column name_upr to your table. Populate this column with a
trigger which uses the upper value
for the new column. Put a unique index on column name_upr.

Uwe