You can change the name of a column in TQL. In MSSQL there is a stored proc called sp_rename that would do it. For getting all fields from a column in a table, that is simply select colname from tablename.
If you wanted to pass the encryptes string into the db, not sure that MSSQL or MYSQL can do. Why not use CF to process the encrypetd name and pass that in using cfprocparam in a cfstoredproc tag? Maybe I am missing the complexity of your objective. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4