Toad World® Forums

CHAR Fields With Leading 0s

Hello all!

I notice that TOAD does not appear to return the leading 0s for CHAR field - ex, if my CHAR(8) field value is 00001510, TOAD returns only 1510.

How can I change this to get the FULL field value? (Oracle db)

Thank you!

Imho it works correctly