Hi friends,
I need to check a table for a record. If the record exists(WHERE clause will include the primary key column), I need to update it and if the record is not there, the entire fresh record need to be inserted. Can some one help me with the query?
And also what if the select query contains a WHERE on non key column?
Thanks
manjunath

[Edited by manjunathk on 01-17-2001 at 04:39 PM]