Hi all,

I'm trying to do a left outer join merge on 2 id's that are concatenated. One table is from Staging, the other table comes from Sharepoint but contains the same information.

E.G. IGS|0|2055. 

The problem is that when I sort this column in my query, the sorting is different then when I sort the column from sharepoint in SSIS. It then generates NULL values because the merge left outer join sorting is different.

Is there any way that I can give this concatenation a better form to sort?