Thanx so much everyone. Sorry it took me soooo long to get back to you but they have me busier than a one legged man in a hop scotch contest.

Be...

Hey Jus, thank you so much for responding. I used your code and I pasted a value from the first record in the file and it bombed.

Please try: set...

Hey Flo my apologies we all know ladies rule ;0)

Jeff, I appreciate the feedback it will be taken to heart. However I am low lady on the totem pole. I'm...

Sorry Jeff.

I hope to one day be worthy of the title SSC Rookie

Even Stevie Wonder would be ashamed of mssing that one.

Thanx much, seems I can't see for looking!

Thanks Champion for the feedback, worth considering.

Hey SSCrazy. I'll try and change my dating ways. LOL

The reason I code dates that way is because the people that are mentoring me code them like that. All of...

I edited and changed the above code, it just might work a little better this way.

Thanks SSC Rookie for replying so quickly. I apologize for not propetly explaining the problem. This job wil be run monthly, starting 12/09/2009 until 03/10/2010. We will need to select...

Thanks so much Bob, after re-reading your response I got it. I wrote the code this morning and tested. I works Great!!!

Thanx so much to all of you. I knew about the datepart function from VBA and I should

have explored it before posting. I was under the false memory that...

Thank you so much Bob, that makes perfect sense. Also thank you for the code it worked perfectly.

Be well

Thank you so much Matt for responding so quickly.

As for the Dupes, I decided to load all of the incoming seq #'s to a table and run a dupe...

Thanks so much to all of you who stepped up and offered you time and talent in solving this problem.

Have a GREAT weekend.

Thanks so much Bitbucket for the feedback. WHEW! I dodged that bullet, Card_Num is defined varchar. However I will keep that in mind for future development.