Empty field on request

[Anonymous]

Hi,

I have an issue with extracting data from a database.

I realise a SQL request like :

select

myfield1 as myData

from my table

But I receive an empty list of myfield1 even though there is data in this table.

But if i write

select

concat(myfield1, '                                       ') as myData

from my table

It works.

But It only filters data where the length is max the length of with spaces I concat.

Have someone already met this issue ?

Pascal