Country code varchar2 issue

[#1]

Team

   I am having two table one for country and client transaction, they kept the country code as varchar2 at oracle. I could not able to match the values based on country code.

country

country_code - varchar2

country_name - char

client_transaction

client_id  - Number

Amount  - Number

country_code - varchar2

Can any one suggest me how can  we convert the varchar2 to character in qlikview to match the codes

country code  details

MEX

ARG

USA

[boorgura]

try using to_char() in the SQL SELECT script and trim() function in the LOAD script