One thing that has always puzzled me is how poeple are gaurding against duplication in columns where people's names are stored.
For example this table has a persons's first and last name. Stars: starID starFirstName starLastName 1 Vanna White 2 Bob Marley problems begin to arise when people begin adding new names to the table. I could make a unique key out of (starFirstName,starLastName) but what happens when someone enters ('Robert','Marley') or ('Vanna','Wihte'). I guess the solution is to force users to do a query for an existing name. Is there a way to do a more "fuzzy" search than using LIKE ? would soundex or something else be the way to go? -- Vincent Stoessel [EMAIL PROTECTED] Linux and Java Application Developer (301) 362-1750 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php