Words can't express how excited I am. I am testing the code and it the hours look good.

Here is a sample.

111322Mon-Fri7:30 AM-5:30 PM

111322Sat8:00 AM-3:00 PM

111322SunClosed

111323Mon-Fri7:30 AM-5:00 PM

111323Sat8:00 AM-12:00 PM

111323SunClosed

111336Mon-Fri7:30 AM-5:30...

I understand. I just am trying to figure it out another way. Honestly, I just don't understand your code enough to run with it.

I'm not having great results trying to loop thru a cursor and track all the changes to up to 5 lines on hours. :crazy:

I'm not getting very far with trying to loop through a cursor. I'll keep working on it.

Thanks again for the help. This is close but I don't think it will work. Here is some output from my data.

111340Fri7:00 AM - 5:00 PM

111340Tue - Thu7:00 AM -...

Thanks so much for your help.

Yes these are two separate businesses. I just gave two sample records. In the data if Sunday Open has a value of "Closed" then Sunday Closed is NULL.