>Without having to use external tool, the only other way I have found to see it from the interface is to increase the length of the column, which could be very long, assuming the value is big.

IIRC, it only works until column size exceeds about 8000 bytes.