Testing for a record before update or insert without using a function.

Is it possible to test if a record exists in a table and then if it does do
an update on that table or if it doesn't do an insert ? I've looked around
the documents and it seems everything points towards a function?

Is this the only way or has someone done this before.....

TIA

Geoff