I am doing a FULL OUTER JOIN on 2 tables. Answerset I am getting is truncating leading '0's for one of the columns. Is there a special consideration/casting that we have to do when we do a FULL OUTER JOIN? The results are coming out fine when i am doing INNER JOIN(no 0 truncation)
I checked the data type of the truncated field from table and answerset and it all shows VARCHAR(6).
Can anyone please suggest how we can get this resolved?
Below query truncating leading '0's for one of the columns