IF - exists -SQL syntax?

I tried somethin like this (based on SQL-server scirpt):

IF NOT EXISTS (select * from table_a where field_a='xxx' ) THEN   INSERT INTO table_a.... ;
END IF; What is a right way to do check that the row is not in the table? Received on Fri Jun 16 2006 - 05:26:17 CDT