Thank you! Worked like a charm!

I checked it out and filled in a comment that I'll be joining and bringing a friend along. Thanks.

Yeah wow absolutely I'm from Bryanston - I'm gonna check it out now.

Gail - I just saw an article by accident on you on Simple Talk - WOW you're like the only SQL Celebrity I know haha - ...and you're from South...

Yes.

Hi Gail

Thanks, I also started thinking maybe tablescan will be the only solution here. I'll see if I can do a full text catalog and maybe write an external...

Thanks Gail - it helps to get confirmation from an expert that I'm on the right path here!

I'm going to try it tonight when no-one's working on the DB and...

Thanks Jack and Jerry - I have decided to rather modify the dataset in Visual Studio and submit the changed records back to a webservice that will just update each...

🙂 Thanks Chris, that worked like a dream!

Dude you're a legend, thanks!

It looks like this now and it works like a dream!

SELECT     c.containercode AS [Container Code], CAST(COUNT(c.containercode) AS varchar(14)) AS [Number of Files], SUM(LEN(c.containercode)

                      + LEN(i.indexfield1) + LEN(i.indexfield2) + LEN(i.indexfield3)...

Haha - no dude you're frackin' clever.

Just one last thing, how do I incorporate the c.subcoid = s.subcoid into this:

SELECT     c.containercode AS [Container Code], CAST(COUNT(c.containercode) AS varchar(10)) AS [Number of...

Adrian, thanks for your reply.

I modified your code a little bit and it works perfectly when it's like this:

SELECT     c.containercode AS [Container Code], CAST(COUNT(c.containercode) AS varchar(10)) AS [Number of Files],...