Hi,
I am using Firebird 1.5 and I want to create a query that updates a
row, or creates a new one if the row does not exist.
I found that in 2.1 there will be a REPLACE/MERGE command for doing
this, but I was not able to find a solution for 1.5 (Other than
checking if a row exists in a separate query).

Is there any way of doing this in a more efficient way?

Thanks in advance,
Ariel Sakin