Thanks Jeff and GSquared! It works great now.

Disregard the last question. I read more about bcp and figured out how to load a delimited record into the proper fields. Thanks for the guidance.

Bryan

Would you load the data into a staging table as one long string including the delimiters?

This process will be used very sporatically. Files are typically around 200 records. Basically, I will read the record in the file, evaluate two columns of the record...

do you want nulls to remain nulls?

Try this...

select

substring(datecolumn,1,2)+ '/' +

cast(month(substring (datecolumn,3,3)+'2007')as char(2)) +'/'