Hi RGR'us

Yeah I did try your suggested query.

However, it did not work.  After much testing, the query seems to have worked when switching fields from char to varchar.  I'm going...

My bad...what I meant to type was:

SELECT tblOne.NameOne, tblTwo.NameTwo

FROM tblOne, tblTwo

WHERE tblOne.NameOne = left(tblTwo, len(tblOne))

But in this case, the len(tblOne) will trim off the last character from the tblOne.NameOne.

This means...

Hi again folks, thank you for your kind replies...

While the 'len' and 'datalength' differences are important for another part of my project, what I am trying to do is join...

I was doing some research and I noticed that the ANSI_PADDING parameter treats trailing spaces differently whether it is on or off.  So I attempted the following statement:

SET ANSI_PADDING ON -...

Sorry about that.

Thanks

Hi Michelle,

Thanks for the reply.

I just checked the table definition and I in fact created the field to be 'char'.

Thanks

Hi everyone,

Thank you for all your help.  After much trying, it turned out the problem was somewhere in Bulk Copy command which I had to try and retry many...

Is there a reason it would give me the unexpected EOF error when I try to copy a file of roughly 500,000 records into the table?

When I only take a small...

Hi again David,

I am not a "pro" with all the lingo of database administration.  Can you please explain to me what you mean by commit?

Thanks!!!

Great, that worked!!!

You've been a great help Mr. Webb.

Now, it's time to try with the real master file!

Many thanks again for all your help and time!

Ok it seems like I am actually getting somewhere.  It is now giveing me the error, "Unexpected EOF encountered in BCP data-file."

My format file looks like the following:

8.0

3

1 SQLCHAR 0...

Thanks for the reply.  I'm actually using a very simple test file and table to try this out first.  So I created a very small table, with 3 fields.  The...