Hi!

In ASP you probably use ADO, so I will write this for ADO (also assuming you use VB script, not a JavaScript):

Set cmdComm = New ADODB.Command
Set cmdComm.ActiveConnection = objConn
cmdComm.CommandType = adCmdStoredProc
cmdComm.CommandText = "MySPName"

' at this moment most likely (for SQL Server OLEDB provider) Command object already will know all
'arameters and parameters collection will contain "RETURN_VALUE" parameter
' maybe add some parameters for SP here to the command obect parameters collection
'...

cmdComm.Execute
If cmdComm.Parameters("RETURN_VALUE").Value <> 0 Then
....

HTH.

>How can i get the value turned back by a stored procedure using ASP ?
>I can invoke it but I don't know how to get the result
>
>Thank u