FILELINK of two items

Hello again, here I am with another "problem"
I want to combine two fields (name + surname) removing spaces on the right to be visually aesthetic.
How can I allocate to property FILELINK column of the combination of both fields?
TABLA.COL_CLIENTE .. FILELINK = LEFT ( "QRY.NOMBRE") this works perfectly, but
TABLA.COL_CLIENTE .. FILELINK = LEFT ( "QRY.NOMBRE") + "QRY.APELLIDOS" what goes in the column is: #####.
If it can do, someone could tell me how.

Thank you.

Message forwarded from pcsoft.us.windev

i think that you have to do it in your query.

Just create a new column in the query with the concat and them link it to the table.
Use something like this:

select concat(NOMBRE,APELLIDOS) as nombre_apellidos from your_file

TABLA.COL_CLIENTE .. FILELINK = "QRY.nombre_apellidos"