help needed with syntax problem

Hi...I'm new to SQL and am trying to convert queries to SQL 8. I have the following Delete query that query Analyzer is giving syntax errors. I can't find any reference or help on the 'PARAMETERS' statement at all. Any help would be greatly appreciated!

Here's the query...

PARAMETERS pTransId Text ( 255 );
DELETE DISTINCTROW tblApTransInvoiceTax.*, tblApTransInvoiceTax.TransId
FROM tblApTransInvoiceTax
WHERE (((tblApTransInvoiceTax.TransId)=[pTransId]));

Here are the error msgs ...

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'Text'.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'tblApTransInvoiceTax'.


Thank you!

It appears you would want to use the DECLARE function instead of PARAMETERS

DECLARE @pTransID varchar(255);
SET @pTransID = 'Some Value'
DELETE FROM tblApTransInvoice
WHERE TransID = @pTransID


I hope this helps.