Interesting. Will give it a try next week.

What I did was I imported the project to local laptop (instead of using VS on the server) and it works. Not ideal...

scottwaltonmcse (10/29/2008)

---

What is the error you get?

Some things to check and do:

1. Is IIS installed on the new SQL box?

2. Have you run Reporting Services Configuration on the...

NM. Google has it. Replace len with datalength.

I don't think I could ever come up with anything like this, espcially from an accountant :hehe:

Thanks all who replied.

ck9663 (10/21/2008)

---

I'll take a shot at it. This is just a sample code:

Run this code:

declare @mytable table (mystring varchar(1000))

insert into @mytable values( 'This is the first line ' + CHAR(13)...

Steve Jones - Editor (10/21/2008)

---

charindex can take a third parameter, the location at which to start. Use the charindex from the first one as the starting point.

SELECT line1 = substring(TXTFIELD,1,charindex(CHAR(13),TXTFIELD))

...