Fetching data with certain condition..

[Former Member]

Hello,

I want to fetch data from custom table such that field ZNAME of table ZCUSTOM does not contain first three characters as 'OKL' or 'okl' .

How can I do this ?

Please help.

Regards,

Jainam.

[Former Member]

Hi

Try to use LIKE option:

 select * from ZCUSTOM where not ZNAME like 'OKL%'
                                         and not ZNAME like.'okl%'
ENDSELECT.

Max

[Former Member]

Do you also want to exclude 'Okl'?

Rob

[Former Member]

Give the statement

select * from zcustom where zcustom-zname = not ( 'okl%' and 'OKL%)'.

This statement should work for you bro.

Regards,

Ankur