Pass field names to stored procedure

[Jeff Carlin]

I'm trying to pass the name of a field to an SP. The fieldname will change from time to time. The resulting SQL statement (if done in VB) would look like

"SELECT * FROM tblMytbl WHERE " & myField & "=" & myVar

Here's what I've got, but needless to say it will not work.

CREATE PROCEDURE myProc

@Parm1 varchar(20)     -- The field
@Parm2 varchar(20)     -- The variable

AS
SELECT * FROM tblMyTbl WHERE @Parm1 = @Parm2

Can anyone help? Thanks.

[JHausmann]

Try this:

CREATE PROCEDURE myProc

@Parm1 varchar(20) -- The field
@Parm2 varchar(20) -- The variable

AS
Declare @Sql_Statement varchar(255)

SELECT @Sql_Statement = 'SELECT * FROM tblMyTbl WHERE ' + @Parm1 + '=' + @Parm2

EXEC(@Sql_Statement)
Go


I'll leave it to you to figure out how to make this work if @parm2 is a string...