Hi Jeff, I'm having the same xp_cmdshell issues. By any chance can you post your script?

Thanks

Did you ever figure out what caused this? I am having the same issue.

I was thinking the same thing, but could not get the CHARINDEX to work, so I added the space then trimmed it off. Works fine now.

SELECT MyAddress, address1, address2=RTRIM(LEFT(address2, CHARINDEX('...

Yes, that looks much cleaner. Unfortunately I can't seem to get it to translate to my data:

SELECT MyAddress, MyAddress as [address1], [address2]=LEFT([address2], CHARINDEX(' ', [address2])-1)

FROM MyTable

-- Remove extra...

Thanks for the quick response, but that's a little more complicated than I was hoping for. I thought maybe using CHARINDEX and SUBSTRING might do it.

I tried that, but it does not seem to work when the amount of spaces vary, for example one column may be '1 north main st' and I need to...

Is there a way to get the first two? For instance I need to pull out 'aabbbb' from 'aa bbbb c ddd ee'. The lengths and the number of spaces...

Thank you all for your help!

So your saying that this code still produces the same result in with the same efficiency? (I took out another join and moved it to the where clause)

INSERT INTO Table5...