--Removed

Yuk. Don't like that proc at all. Looks like it was written by a procedural programmer unfamiliar with T-SQL concepts like 'sets' 🙂

Have you thought about writing your data to...

"Can't" is a strong word. Multiple Replaces can be nested, so, with care, this might work.

Here's a nested Replace example:

declare @x varchar(100), @y varchar(100)

set @x = 'abcdefg'

set @y = replace(replace(replace(@x,'a',...

His real name is Crispin 🙂

Merely repeating your earlier...

Are you sure that there are no other more-detailed error messages?

Do you know which step is failing? What is it trying to do?

Is there any chance that you could get the spreadsheet exported to .CSV format as step one of the process? Then you should find that the limitations are removed.

Check your 'State - 1' bit - you are performing arithmetic rather than subtracting one from the length. You need to rejig your brackets and all should be well.

captcooldaddy (2/22/2012)

---

the above is a quick and dirty solution w/ pseudo code because you're not really providing the proper preface to give a detailed solution however it should suffice. Pretty...

Thanks Jeff, I appreciate the genuine tone of your message. And I sympathise with the sleep deprivation - sense of humour is often one of the first casualties. I'm also...

Phil... go easy on us non-pro English abusers... we do this to help, not to get "A"s in grammer. I know many ESL's that absolutely trash the English language and...

I must apologise - I was being hard on you because I thought you were a native English speaker. But I reread your posts and I don't think you are,...

Hmmm, 'corrected' version:

I suggest you quit digging :w00t:

My answer to this question is: "Huh?"

Please reread Koen's response.