Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

retrieve data with restrict document number

Former Member

‎2008 May 21 4:04 AM

0 Likes
349

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

1 REPLY 1
Read only

Former Member

‎2008 May 21 4:07 AM

0 Likes
331

Use

SELECT * FROM dbtab WHERE docnum LIKE '19%'