>Jim,
>
>I need to, for example, store the time interval ( 2:30 PM - 5:00 PM) that this particular customer is available. I need to be able to check for conflicts using that data. So I can't store it as a string.
>
In order to check if there's an opening, you need the date, too, so why not store two datetime fields for start and end times? It's jsut as cheap on storage as a Date and two integers (two datetimes are 8 + 8 bytes, while a date + two integers use 8 + 4 + 4 bytes)
>Gnana