You can try
select length(trim(' 100'))
Regards,
Hanumath
Attachments
Library
Quick Reference
Archives
Sample Index
2011 Indexes