I realize that I would have to use a stored procedure.

My question was how do I pass a variable to this stored procedure from a vb app and vicea versa.

Thanks!