Hi all,

I'm trying to do a stored procedure that does a select with parameters and then, if records aren't found, do the insert and proceed with the DML.

I have to implement this as a Stored procedure (thrid party app) and I'm stumped. I tried to google it but there were a gazzilion examples and none of them had this example.

something like:

Select name, surname, address from client where SSN = 1234
if not found (or recordcount = 0, or empty = true) then
insert (name, surname, address, SSN) in client ('john', 'doe', 'aa street', 1234);

Edit client set total_bought = total_bought + 100.00;

Thanks
Andrew