Substitution of column names

Hi Everyone,

I there a simple way to select a column from a table, based on what a user inputs?

My table has the following columns

	FUND
	ORGN
	ACCT
	TOTAL_01_BUDG
	TOTAL_02_BUDG
	TOTAL_03_BUDG


	.

	.

	.

	TOTAL_12_BUDG

My select statement is
	SELECT FUND, ORGN, ACCT, TOTAL_nn_BUDG
	FROM MYTABLE;

Every month the select statement changes. Is there a way to have the user input the cycle (01, 02, ... 12) and then insert what the user inputs into the column name? Otherwise, every month I have to edit the script to change the 01s to 02s, or the 02s to 03s, etc.

I have thought of creating a temporary table, and of having 12 select statements in the script...I'm just curious if there's a way to substitute with what the user inputs.

Thanks for any suggestions.

• Maureen English Systems Analyst University of Alaska snmte_at_orca.alaska.edu