retrieve data with restrict document number

[Former Member]

hi,

i want to retrieve the data from table into internal table, where the document number start with 19********.

so how an i going to code it so that anything start from 19***** will be taken only, and others are not?

thanks

[Former Member]

hi,

i want to retrieve the data from table into internal table, where the document number start with 19********.

so how an i going to code it so that anything start from 19***** will be taken only, and others are not?

thanks

[Former Member]

Use

SELECT * FROM dbtab WHERE docnum LIKE '19%'