Thanks Phil

Worked a treat.

Probably because what you are looking for doesn't have a space?

Adding NULLIF would be a good start

… DESCRIPTION_1,NULLIF(CHARINDEX...

hope this helps?

Thanks Mike

I ended up doing this

;WITH First4Count_Cte (Invoice, First4, First4Count, Amountmst) AS (

select

Invoice,

First4,

row_number () OVER (PARTITION BY First4 ORDER BY First4) as First4Count,

Amountmst

from tbl_test

) select * from First4Count_Cte

where First4 in...

I never got to the bottom of it. I had to format my server, install Windows 10 Pro and then install SQL Server 2016

Frustrated there was never a...

Thank you fellahs I will try both suggestions. However I have been down most of those routes before.

I simply can't believe it can be this difficult and such...

Wow thank you that is amazingly simple.

Many thanks again

Thanks Gail discovered the answer also about 30 seconds ago. Thank you again.

I understand - it works for what I want.

I will now educate myself on the query itself, take it apart etc, put it in my armoury

Thanks you sir

Thank you Louis - I haven't used CROSS TAB before, makes life a lot easier than trying to use something not designed for transposing.

This is all I need I think....

Hi Drew

I thought I had included the expected output as an image.

You are correct it's wrong of me to call this a PIVOT in the truest term, it is a...

Hi All

I found the solution right here on SQL Central, after lots of heartache, frantic Googling and numerous SSIS testing.

The answer is here:

We had this on this site however the...

Every time I have had this issue it's all been down to permissions on folders. You may not have any folders in your SSIS package but if you have, your...

It's as yours above only the code is running against the real tables with the full content, yesterday I made smaller tables to help find a solution, which you did...

Hi Chris

This does indeed help me a lot, however I can see that the code checks every single combination of the short postcodes against the squished post code until it...

Thanks Chris but the CV .... blah blah was just an example. The table I created with code has a subset of the postcodes I have ranges for.

Thanks anyway