Thanks to you, Nick and Ricardo for the input.

Sometimes I have overlooked the power of SQL. Thought that there may have been an opportunity to exploit SQL here that I didn't see. Glad to know that I didn't drop the SQL ball this time.

>Hi Dennis...
>
>It looks like you are filling in records. SQL is about fetching existing data. What you are looking for are cursor-based operations that fabricate/derive the data based on existing data. In this case, it is not so much fabricating data as it is creating records that do not exist.
>
>Nick's suggestion is the way to go, regardless of whether it is VFP data or SQL data. FWIW, you can do the same sorts of cursor operations in T-SQL on SQL-Server...
>
>>I want to take a table that looks like this...
>>
>>Beg-year End-year Details
>>1975 1979 blah,blah,blah
>>1981 1984 yak, yak, yak
>>
>>and turn it into this...
>>
>>Year Details
>>1975 blah,blah,blah
>>1976 blah,blah,blah
>>1977 blah,blah,blah
>>1978 blah,blah,blah
>>1979 blah,blah,blah
>>1981 yak, yak, yak
>>1982 yak, yak, yak
>>1983 yak, yak, yak
>>1984 yak, yak, yak
>>
>>Is this possible? Please advise.
>>
>>THanks.