Load data from database using concatination

[#1]

Hi all;

i work with database Sqlserver in our server  , i succeded to have connction between Qlikview and Data base,

I selected the values that i want to load  like :

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False; ..........;

SQL SELECT

code1,code2

from ......

i want to concatinate these two code  like :

SET Verbatim = 1;

LOAD Distinct Text(code1&code2) as Concat   

FROM    database.table

how do i do for loading this COncat please

thanks all;

[#2]

probléme resolved , i used in to load an original name from SQL select , but in select sql i used renemad field

thanks brother

[oknotsen]

Please flag the Correct Answer and possible Helpful answer to close this topic. Thank you.

[#4]

probléme resolved ,

i used in to load an original name from SQL select , but in select sql i used renemad field

i wish that helpful for other

thanks