Fieldname as parameter..? 1

[kenjoswe]

Hi all,

Is it possible to substitute a fieldname in a stored procedure with a parameter something like:

@Field varchar(50)
select * from Table1
where @Field= 'criteria'

/Kent J.

 

[cdukes]

Yes,
But you will have to exec the statement:

DECLARE @Field varchar(50)
DECLARE @Str VARCHAR(255)
SELECT @Field = 'MyField'

SELECT @Str = "SELECT * FROM Table WHERE ' + @Field + ' =
'''criteria'''
EXEC (@str)

I think this is what you mean,

Chris Dukes

 

[kenjoswe]

Thanks! That really helped me!

/Kent J.