Search in select query

[Former Member]

Hi All,

I want to search table fields

select auart bezei from tvakt into corresponding fields of table itab.

now I want resctrict the selected values of field bezei to the ones that starts with 'Z'.

Pl send me sample code

Points assured

Regards

Shashikant

[Former Member]

Hi All,

I want to search table fields

select auart bezei from tvakt into corresponding fields of table itab.

now I want resctrict the selected values of field bezei to the ones that starts with 'Z'.

Pl send me sample code

Points assured

Regards

Shashikant

[Former Member]

select auart bezei from tvakt into corresponding fields of table itab

where bezei like Z%.

This query will return all ther records where bezei starts with z.

Reward if helpful.

Thanks,

Imran.

[Former Member]

If you want more flexiblity, put the search string in search string

CONCATENATE '%' Shashi'%' INTO srch_str.

select auart bezei from tvakt into corresponding fields of table itab

where bezei like srch_str.

This will query all the bezei which has shashi anywhere.

Reward if helpful.

Thanks,

Imran.

[Former Member]

Thank you very much imran for ur previous answer

I hv rewarded ur answer

But in the same select query when I am trying to select auart which ha two alphabets LP it is selectin it correctly but it is giving me some two entry which has only two lettelrs DS

which is not supposed to come

but when I am checked the table tvakt on the basis of value DS it is giving me means diplaing the same entry with LP n not with DS

Regard

Shashikant