First I want to thank you guys for your help and suggestions.... I did figure out what was going on and it seems pretty bone head on my part but...

I think there is something in the list file that is causing this headache. I added a second column to it to see if having a column delimiter would help...

2 posts up the sq.png shows the results

When I query the entityname table with a value copied from the namefile table I get the results I was looking for

but...

and 1 blank row that I don't know why its there so there are 112 Look at the attachment

Could this be causing the problem .. and I shouldn't have it...

ok so

This works fine select * from EntityName e where e.EntityName = '17L-52W7 KVAR'

But this returned nothing select * from namefile n where n.Listname = '17L-52W7 KVAR'

So there seems to...

I checked the raw file and did not see any extra special chr that would cause a LF/CR.. I was using Notepad++ to check it

A spreadsheet was originally generated from the entityname and measurementlimit tables. The csv file is generated from that spreadsheet so the names are correct. as you can see in these...