Guess I'm showing my age. Didn't it used to be supported? back in the SQL 2000 days?

Thanks for the input Michael. I'll try to refine this design and come back in a couple hours and post the results.

I'll give it a shot. I could tell the performance would suffer by embedding all those selects.....

Thanks! That's actually what I was going to try but I thought I'd have to end up using it in conjunction with InString or FindSting or something similar.....

Will do. Will post back here later today with results.....

Interesting!! Thanks. I will look into....

Thanks. No, they are not on the same network or domain. Internal vs offsite, 3rd party web hosting company.

Corrected. Removed "BEGIN".

Works so far.

Hahaha.

OK. I need a break from this. It's a literal string! Haha.

I thought it was some clever Union or something.:-D

Excellent. Thanks! Sounds like a good Monday morning reading....:-)

That's kind of the direction I'm leaning towards as well. Although it contains duplicate data, I don't mind having a staging database that can be trashed and recovered at...

Good point. It's about 4000 records that would call this function.

The data is pretty dirty. I'm pulling from a mainframe and retrieving First Name, Middle Name...

keebler96 (7/10/2013)

---

The problem is likely when you are using the import wizard for sql server... It defaults the column output width to 50 characters... You have to click...

I feel that I should also mention that the Import "Preview" seems fine. It shows me the first 100 records in a preview window and all seems fine. I...

(I like the idea of multiple Catches. Nice!)