topic Re: Fetching data with certain condition.. in Application Development and Automation Discussions

Fetching data with certain condition..

Former Member — Fri, 11 Sep 2009 15:37:27 GMT

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 — Fri, 11 Sep 2009 15:42:28 GMT

Try to use LIKE option:

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

Max

Former Member — Fri, 11 Sep 2009 15:46:31 GMT

Do you also want to exclude 'Okl'?

Rob

Former Member — Fri, 11 Sep 2009 15:49:39 GMT

Give the statement

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

This statement should work for you bro.

Regards,

Ankur