Search program on table

[Former Member]

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]

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]

Chris,

You can directly write a select query like below.

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

Raj