I just want to add my thanks for this info. I have to fix names a lot in my job and I have wondered how I would do it...

I second Jeffrey's suggestion. I have the Melissa Data software and just recently used it to fix names that were in lname fname mname format. Go to MelissaData.com...

I had exactly the same problem. The experts within my company persuaded me that there was no way around it except to use BCP instead of BULK INSERT. ...

Your suggestion didn't work, but it put me on the right track and I really appreciate that. It turns out to be a programming problem that occurred before I...

OK, I ran the length function against the mrn field in both tables. In the CMBD table the actual length of all entries is 6. In the PCMBD...

That's a pretty neat site. I wish I had known about it a few months ago. Unfortunately, the only client we had whose application was written in cobol...

Well, yeah. A year or so ago nobody would believe I could learn to program in C# - which I have. The problem with having been a COBOL...

I tried your suggestion and it looks like it worked. I wanted one occurance of each MRN no matter which table it appeared in or in both and it...

I lost the where clause but it still doesn't work. Maybe I am going about this the wrong way by copying the way it was done in Access. ...

Yes, that was my problem. The SQL 2000 that I had was a local installation. I have been informed that I need to have the network gurus give...