Hello everybody,
If I have this schedule:

            Monday Tuedays Wednesdays
Mathematics 8 10 11 12
Languajes 8 10

And on monday I have two different subjects at the same hour, how can I make a program on ASP to detect that I have two repeated hour the same day?. 8 10 means: From 8 AM to 10 AM.
Help me please.

Well,
To start of with, you need to put a bit of structure into your data. Start by defining a simple Subject structure that would include:

- Subject name
- Day of Week
- Start hour
- End hour

Once you have all the data (You haven't told us if you are using a formal database...) loop through the data and if you can find two rows with the same Start hour and end hour for the same day of the week, then you have spotted a schedule clash.

Cheers, Joel

Hi Joel and thanks for your quick answer.
I'm using an Oracle database and I already have the program with Forms and it works pretty well, but I have no idea on how to do it with ASP. I was trying a few codes, but it didn't work because first thing is that the data I have is Varchar and I don't know what command to use to get to the next hour, for example: in Oracle the way I do it is just like this: If substr(schedule,1,2) between substr(schedule1,1,2) and substr(schedule1,3,4) then
message('You have a clash...please verify');
End If;
If you have some code that could help me, I will be very thankful because I'm not a pro with ASP yet, only Oracle and Forms.
Thanks a lot!!.