Hi!
I only have a small question it is possible to select some field using a
variable instead of a specific name ?
Some thing like this :
DECLARE @FieldName VARCHAR(25)
DECLARE @ID INT
SET @FieldName = 'FileName'
SET @ID = 10
SELECT @FieldName
FROM TABLENAME
WHERE ID = @ID
I don't want to use some thing like the command "EXEC ('SQLQUERY')" ...
Thank!
Yanik Lupien
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/sql@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
