Chris,

Null becomes "." if I understand your string. And a simple scan/endscan with a nvl( WhateverFieldGivesYourLetters, "." ) should work.

>Guess I didn't explain well or ask the question right. Getting the dates to/from SQL was the easy part. The hard part is converting it all to a string that properly adds periods for the missing(holiday and weekend) dates.
>
>Your solution would give me a cursor that includes missing dates... halfway there. Walking that cursor could work, but I have to solve another issue with skipping/ignoring completely empty weeks.