RecordSet DS and leading zeros

Hello,

I have a CFF field set as RecordSet DS with a query like this:

SELECT * FROM mytable WHERE codice_2="<%fieldname185%>"

The <%fieldname185%> can contain something like 04848484848.

But the query results are empty when I use the <%fieldname185%> variable and search for something with leading zeros.

If I set a query like this:

SELECT * FROM mytable WHERE codice_2="04848484848"

then, it works.

Perhaps there is a sort of sanitization on th fields? Or leading zero are removed on the fly?

How can I make my query works even with leading zeros values?

TIA

tony