WHERE (@ColName=...) - Not Good?!..

Hi, gurus!


Of course, you know that this:





... WHERE (COLUMNNAME = @PARAMETER)





works perfectly, but the opposite - when I need to pass


a column name as a parameter - the SQL Server 2000 cursing me...





I was designing some stored procedures and here is what I need:





... WHERE (@COLUMNNAME = 1)





^^^ I need to use a different column names here, so I decided to use


a parameter, but it does not even budge. Of course, I can use workaround:





IF @COLUMNNAME = 'External' THEN


BEGIN


SELECT ... WHERE (External = 1)


END





But, I SO! do not want to do it 9 times - I have 9 column names


to check...





Maybe, there is another way to do it?..





Thanks,


Cheers!