Thanks I got this to work, and this really helped.

Thank you

I see what I did not make clear, sorry about that, I had this in my question "And keep in mind please, I will have multiple dates to do this...

Hi,

I am sorry maybe I am misunderstanding it, I will try putting it in and see what happens thanks, guys.

Thanks for the reply, but I can not do that.

I am taking a time like 10:02:00 and looping through the table above and checking this for each row; like I...

HI,

and thanks for the reply.

I do have a full version of VS, but am not familiar with how you do what you do in SSMS in there?

Please let me know.

Thank...

Thanks that is a great idea too.

thanks for the post it looks like a great article.

thank you

This really gives me some good ideas.

sorry, I meant use

Thanks again for everyone's help here

Okay, that does look good.

Thanks

yes, it is a varchar(), and yes I know it should be a Date but I do not think I will be able to change it.

And I could use a...

Thank you

I git this to work

Sorry, I am not sure how I would use DATEDIFF  here, because that needs two dates I think.

Thank you

That did it.

Thanks, I really appreciate your help.

Thank you