strings and numeric calculations in same field

strings and numeric calculations in same field

I have a fairly complicated query, which includes a field that has strings and numeric calculations concatenated. It looks something like this:

SELECT INT(COL_A) || ' to ' INT(COL_B)
FROM ...

When I execute it in the edit mode's preview, it looks okay. when I save the query and execute it in view mode, it puts gobbletygook in there (looks like it might be a pointer). EG: [B@619a1a10c

they all begin [B@ followed by a number in Hex, which makes it look even more like a pointer.

- Paul