Try the UNIQUE keyword when creating your table..
On Tue, 25 Jan 2005 09:34:53 -0500, Steve Frierdich <[EMAIL PROTECTED]> wrote: > Does anyone have any code they can send me that shows how to check for a > string in a column in a table, and if the string is not there on how to > insert the string in the column in the table in a new row. Then finally > on how to update the table? > > And if possible on how to maybe write a trigger for the above operation > and use the trigger in a Visaul C++ or a Window's 32 program? > > Thanks > > Steve > 727 455 4668 > 727-547-9799 ext 1766 > > -- Cory Nelson http://www.int64.org