Issue Comparing data in an sql server DB

[rickymartin06]

i need to compare 2 tables in my database tutor and student

i have in student table: name, id , starting_schedule and finish_schedule gathering in there the time the student start a course and when the class finish for example if i have class from 8 - 10 it will say starting_schedule = 8 and finish schedule = 10 i need to compare all the schedules in the table with the available time in tutor table for example i have in student 8 - 10 11-12 1-2 and i have in tutor available_Time = 9 available_Time = 10 available_Time = 11

that mean tutor is available at 9 available at 10 and 11

how can i compare the info i have so i know if i can put that student in tutoring at that time?

*sorry for my english

[GaryMazzone]

How are the times stored? As Times? As String? What database?

[rickymartin06]

it's stored as string

[rickymartin06]

my main question is how do i compare data in a database i need to compare 2 values in the database

[GaryMazzone]

You compare by using a between statement.... the problem you will have is that they are text and this will cause problems trying to get the values correct.