I know we're not in the business of copying mySQL, but the REPLACE INTO table (...) values (...) could be a useful semantic. This is a combination INSERT or UPDATE statement. For one thing, it is atomic, and easier to work with at the application level. Also if the application doesn't care about previous values, then execution has fewer locking issues and race conditions. comments? Dale Johnson ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]