exit stored procedure - a newbie question

[nir gallner]

Hi,

I am writing a stored procedure, and I want to exit the stored procedure some where in the middle if some condition is true. For example:

-----------------
CREATE PROCEDURE `cwa`.`insertWord`(wordId mediumint(8),status tinyint(1), res INT)

BEGIN

if word is null or word ='' then
set res = -1;

else
...
END
-------------------

I want to exit after assign res = -1. How do I do that? I thought of handlers, but I only found reference to Mysql server errors in connection with handlers and not self generated errors.

Thanks