# 4786 CASTing BLOBs to VARCHARs Causes Incorrect Record Values in Result Set

---

I've just noticed an issue when performing a query that casts a blob field as a varchar where it seems to be repeating values from previous records.

With the attached table when I perform the below query I get the following result:

22436,"FormSetup","cbEmailWhitelist","GLOBAL",,"amanda.bortone@viterra.com"
22437,"FormSetup","cxPITreatSentListasProcessedTk","GLOBAL",,"0manda.bortone@viterra.com"
22438,"FormSetup","cxPIAutoSendShipmentAppropriationOnFinish","GLOBAL",,"0manda.bortone@viterra.com"
22439,"FormSetup","cbCheckCAN","GLOBAL",,"-1anda.bortone@viterra.com"
22440,"FormSetup","cbCheckContainer","GLOBAL",,"01anda.bortone@viterra.com"

If I export Record 22440 - I only get '0' in the exported file. It seems as though when performing a cast like this, it's not clearing the expression from the previous record.