Renaming fields in load script

[#1]

In my data i have a field "AvgYear" which currently holds results of 1, 2, 3 and notavg.  "1" represents the time period April 2010 through Mar 2011, "2" represents April 2009 thru Mar 2010 and so on.  How do I code or alias my AvgField in my load script to show the actual period in my list box?

Hope this makes sense.

Jennifer

[#2]

Pick(AvgYear, 'April 2010 though Mar 2011', 'April 2009 through Mar 2010'...)

I'm not sure what notavg means though. If it isn't a number, then you may need something in addition to the Pick.

[#3]

Thanks. I will try this.  Do i add this statement prior to the load or after my first select * statement?