Actually I suppose that that could be done although in the end the value of daterange will need to be passed to a file name. In fact it is a...

it has to be char or varchar since it contains a date range in the following format 'June 2 thru June 3,2008'

well the type is string which should be adequate (there was a typo)

I have run into a problem that your piece touches on. I would like to put the value of a date range into a variable. Specifically select daterange from tablea...