Tony,

Good point, I really don't need to delete those records, I can select out. I never thought of using a select substring to get the data in the format....

Tony,

Thanks for taking the time to respond

That is basically how I am handling this now. I import in one char (first char) & one big column then delete the rows...

the data is coming in a fixed width text file

Thanks for the help. I will investigate user defined functions. I think I will be able to use these in other areas.

I tested the other solution provided and...

Wow, that was too easy.

Thanks so much. Tested that and it worked perfectly.

Thanks for this article. I learned something new and I will be using derived tables in the future. I would not consider myself an expert but I am...

Thanks Grant for the data add comment. The test data was in a text format so I didn't use this.

The reason I am subtracting a date is so we don't...

I think I figured out a way to determine the end date for each corresponding effective date. See below. I would appreciate feedback from any experts out there.

select...