SQL Column ranges into rows

[Pete Helgren <Pete@xxxxxxxxxx>]

Wresting with some database conversion issues.  Actually, I don't want 
to the database to change, I want my application that accesses these 
different databases to change as little as possible so building views to 
present the data in a similar fashion is what I am after.

I have a table that could either be in this format:

code, date
with data that looks like this:

'test', 20080115
'test', 20080116
'test', 20080117
'test', 20080118

OR I could have a table that looked like this:

code, begin date, end date
'test', 20080115, 20080118

What I would like do is have a view that structures the second table 
like the first.  If the two dates are the same, you get one row with 
code and date.  If you have a range of dates that span 6 days (for 
example), then there would be 6 rows generated by the view.

Is this possible?

Thanks

Pete