[sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE AND IF STRING IS NOT IN THE COLUMN ADD IT

[Steve Frierdich]

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