How to take specific range of digits from internal table field in where clause ?

[titanium]

is there a way to restrict where clause in select statement so it take only first 10 digit of internal table field ?

[Sandra_Rossi]

You say "Internal table", so are you talking about FOR ALL ENTRIES ?

SELECT ... WHERE column LIKE '1234567890%'

or in ABAP >= 7.40 SP 5 :

SELECT ... WHERE left( column, 10 ) = '1234567890'

or if you're talking about FAE :

SELECT ... FOR ALL ENTRIES IN fae_itab WHERE column = fae_itab-column(10)