i have an one problem. i have two field in my "shift" table
1) from_time varchar(20)
2) to_time varchar(20)
in both field stored data format is like this "10:30 PM"
and i have an two textbox
in that both textbox store value like this "12:30 PM".
now i m writing linq query and i want to match like this
"operation_start_time>=from_time && operation_end_time<=to_time"
how can i do ??? plz help me its urgent......plz some one help.......