Firstly, thank you all for your replies...in a word, you guys are pretty awesome at this whole SQL "thing" 😀

I went back to my original design and changed the StartTime and EndTime values to TIME as Greg mentioned and have used both Greg and Dwain.C's implementations.

Thanks again for all the code, but more importantly your reasoning and discussion behind why you did what you did. At least now I'll have some knowledge and some examples to back it up! 😛

Cheers,

Kev.