insert iff !exist

I'm pretty sure someone already answered this, but the mail archive isn't
very searchable at the moment. How can you

if(update row fails because doesn't exist, ie. returns 0)then(insert row)

in SQL? Or am I misremembering and it was in some other language?

Cheers,

Patrick