I've been writing SPs for MSSQL T-SQL for many years but I'm new to
Firebird and SQL99 stuff. Here's a simple (I thought) SP that won't
compile..

CREATE PROCEDURE SP_PLAYERFIND ( PLAYERNAME VARCHAR(16) )
RETURNS ( PLAYERKEY NUMERIC(15,0) )
AS
BEGIN
SELECT PKEY FROM PLAYERS WHERE PLAYERNAME=:PLAYERNAME
INTO :PLAYERKEY;
SUSPEND;
END

The error returned by IBEasy SQL tool is "Unexpected end of command".

I've tried many different ways of entering this in various
upper/lower case, with/without semi-colons, with/without "suspend"
combinations. I always get an error when I try to compile it.

I'd -greatly- appreciate your expert advice.

:-)