Hello,
Here is my stored procedure:

ALTER PROCEDURE sp_storedprocedurename
(
	@Parm1 char(8)
         @Parm2 char(11)
)
AS
	SET NOCOUNT ON;
SELECT field1, field2, field3 FROM wire_by_part WHERE (field1 = @Parm1)

What I would like to do is return @Parm2 as a column in my returned dataset. I tried having SELECT field1, field2, field3, (@Parm2 As field4) as my Select statement, but I got an error. Any advice? Thanks!

-MAC