SQL if statement...

[lidds]

What I want to be able to do is inside a SQL stored procedure perform a SELECT query and if that SELECT query returns 0 rows then an UPDATE query is performed

I know this is probably really simple, but I can't seem to get it to work

Thanks

Simon

 

[InertiaM]

IF (
      SELECT
        COUNT (ANYFIELD)
      FROM
        ANYTABLE
      WHERE
        ANYTABLE.ANYFIELD = 'criteria'
   ) > 0
BEGIN
  UPDATE ...
END