REPLACE vs INSERT/UPDATE

Currently I'm checking to see if a value exists in the database before deciding whether to update it or insert it. Would this be quicker to do if I merely used REPLACE? Is that the purpose of the REPLACE command? If it exists, just update it, and if it doesn't exist, insert it? Thanks,

Re: REPLACE vs INSERT/UPDATE

At 4:27 PM -0400 9/21/01, Jason Frisvold wrote: Currently I'm checking to see if a value exists in the database before deciding whether to update it or insert it. Would this be quicker to do if I merely used REPLACE? Is that the purpose of the REPLACE command? If it exists, just update it, and