No, I cannot post the unmodified data, it is private. The code and illustration details what is returned. I changed the account numbers which is not significant.

Another point. The field does contain Null values. Therefore, the real error to deal with is:

Invalid length parameter passed to the LEFT or SUBSTRING function.

Any...

Sample data from the field I am using charindex on is listed below:

File Name:BTPN_02042011 BFTPN_02042011| Vendor: Urban | Product: Trial Offers_SD10-01 | Letter Type: Trial Offers_SD10-01 |...

This one is tricky. I tried the "Is Null" at the end of the statement and the error returns...

Invalid length parameter passed to the LEFT or SUBSTRING function.

That was it.

Thanks,

Verlin T.

I tried you suggestion, but it returned the following message.

StartTime is invalid in the select list because it must be contained in an aggregate function or group by...

I am not sure it will work. I was hoping someone had the same experience.

The P1_start, P1_stop fields are fields capturing the time. Prod_Hrs and Paid_Hrs are aggregated. I had to had the others to the Group By Clause. ...

Sorry for not cleaning up the code. However, I am having problems with the code returning multiple lines for the SOEID. It should return one line...

I am currently exploring the rank function. Hopefully, this will work.

VT

Entry_ID TimeStamp Activity_Code

670242 2010-02-15 ...