This almost works:

WHERE ModelName0 NOT IN

(

SELECT value FROM String_Split(@Job_numbers, ',')

)

But when you run the query it builds a list, but after the first row there is space at the start...

sorry, I meant READ file not Create file

Wow!  Very nice. 🙂

Yes it worked perfectly, and yes I have to invest more time into learning.  Your criticism is well placed.

Hi thanks,

hmmm … this looks rather complicated.  I just need to make column into a row and the second column to stay a column.

Hi,

My issue is that I " don't know the number of Manufacturers or Cartypes -...