Neil,

> Can't work out how to make Yahoo groups show the code with formatting so I have pasted here:
>
> http://pastebin.com/63xxsbMK

The stored procedure creates just fine.

- What's the exact error message you get?
- With what tool are you trying to create the stored procedure?

--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!