topic Search program on table in Application Development and Automation Discussions

Search program on table

Former Member — Wed, 12 Aug 2009 14:43:31 GMT

Hi,

there is example how to do search for prefix on table with program

for example if i search for the word man*

i want to get the manager us manager uk

and not general manager

Regards

Chris

Former Member — Wed, 12 Aug 2009 14:48:52 GMT

Hi Chris,

You can see the following code snippet.



  select single name 2
    from adrc
    into l_name2
  where name1 LIKE 'MAT%'.

Here the name 1 that starts with MAT.. will be fetched.

Regards,

Vimal.

Former Member — Wed, 12 Aug 2009 14:50:00 GMT

Chris,

You can directly write a select query like below.

select * from <tab>  into <itab> where <field> like 'MAN%'

Raj