David
[ mysql,query ] > update CompanyContacts > set ByEmailAddress = '[EMAIL PROTECTED]' > where Description like '%marve%' Can you show us the output of: describe CompanyContacts ...and also what is the exact error message? Are you connected as a user who is allowed to update the CompanyContacts table? I often have "select only" users and forget that I can't update/delete etc on the database tables :-) DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) --------------------------------------------------------------------- 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