well in theory the SSIS import of the file and using the " as a text qualifier should eliminate the issue, and it does when previewing the data etc, but...

i found that earlier. I am using a Bulk insert task to import the csv file into the table. I just dont under stand why the preview in the connection...

I think I see what is going on. The table I am comparing to does not have "" in each field.

The table I am pulling data from has...

i figured it out...sort order was not defined in the insert statement.

Anyway, I tried the whole alias thing and your case statement, and I still get A as...

this is actually the SP...

you can see its taking data from a table, and inputting data into another table based on situations.

Just basically manipulating the data...