Syntax for Stored Procedure Pervasive 8x

Pervasive 8, WinXP client

Hi folks, I've just started working with Pervavsive and am simply
trying to create an Update Stored Procedure.


CREATE PROCEDURE spTestUpdate()
AS
BEGIN
SELECT TOP 1000 "Part Master".PMDES1_01, "Part Master"."UDFKEY_01",
LENGTH("Part Master".PMDES1_01)
FROM "Part Master"
where "Part Master"."UDFKEY_01" ='R' OR "Part Master"."UDFKEY_01" ='RS'
END

I'm gettign syntax errors.
Looking online I have seen some samples using an ";" for end of
statement marker, others that do not use it.

Questions:
1. What is the proper syntax for the stored procedure?

2. Where is a good online resource that shows Examples of using
Pervasive SQL?

Thanks in Advance!
-andy

.