retrieve data with restrict document number

Former Member — Wed, 21 May 2008 03:04:20 GMT

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

Re: retrieve data with restrict document number

Former Member — Wed, 21 May 2008 03:07:16 GMT

Use

SELECT * FROM dbtab WHERE docnum LIKE '19%'