my higher person asking us to eliminate the funtions.

Hi Paul White NZ

Its was nice. But one clariffication. here Starttime and endtime is nchar(10) type.

i need to get the result without using any functions.

I need another one...

thank you Atif Sheikh.Its really helpful. I got exact result.

hi SSC Journeyman

My problem is, that i cant say this exact start and end time in my table. it may change. Shift may also extend . but...

im using sql2005