Re: Replace into...

Hi Chris.......

> The problem, though, is that I need this type of functionality... To
> INSERT or UPDATE depending on whether or not the record is already
> there.  I've spent the last several hours trying to figure out how I can
> set up a trigger to do this.

Don't know about a trigger, but the way I do this is do a SELECT, if no
rows are returned I do an INSERT, if rows are returned I do an UPDATE.

Somebody else probably has a more clever way to do it though......

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
     Check out my Musician's Online Database Exchange (The MODE Pages)
                        http://www.TheMode.com
 ==========================================================================