>Probably prototyping it in ADO would work and you would check with >NextResultSet. Also you might try:
>{? = call storedProc(?,?,?)}

Could you clarify this, please? How would call to this function look syntaxically?
CREATE PROCEDURE usp_test
@Number INT,
@NewNumber INT OUTPUT
AS
SET @NewNumber = @Number + 3
RETURN @NewNumber
GO

I just don't know where I'm supposed to put quotation and question marks, brackets, where variable names go etc.

Thanks