Skip to Content
0
Former Member
May 29, 2008 at 10:36 AM

where condition in select query

329 Views

my requirement is this. I want to fetch some records

from DB table. The field objnr has 12 characters.

i will supply a substring of this field. the substring

starts at the 3rd location of field.

SELECT objnr FROM cosp INTO TABLE gt_itab

WHERE objnr like srch_str.

how to do this? could u give me a possible solution?