Converting integer type to char and getting length in sql Reading Time: < 1 minuteselect * from TIKY.IKY_TPERSONEL PT WHERE LENGTH(TO_CHAR(PT.IKY_PER_SCL_NO)) = 5; Share this content @ Share on FacebookShare on LinkedinShare on XingShare on TwitterShare on PinterestShare on Reddit