MySQL Procedure

[aztec]

Hello
I do not know if this is the correct forum but because it is MySql and that is half the problem then here goes.
Normally I use MySQL but I need a stored proceedure in Access 97 and I do not use that programme at all it creating a problem for me.

In MySql I would write it as follows:

[code]
CREATE PROCEDURE dbo.ParagonArchiveRefs
(
@matdesc nvarchar(20)
)
AS
select mastdesc, matno, storedate, storageref
from paragon...matter
where matdesc like @matdesc 
[/code]

Any help or direction appeciated

Kind Regards

[artacus]

You might have better luck SQL Server section.