Sorry

substr(fieldname,1,length(fieldname)) shows something like this on toad:

Code:
OracleProgramming               |  
OracleplsqlProgramming          |
I can see spaces/nulls ..