topic Retrieve not empty data in Application Development and Automation Discussions

Retrieve not empty data

Former Member — Thu, 27 Sep 2007 10:57:02 GMT

I would like to query a data specify the field is not empty, like

Select ... from bseg where

augdt <> ''.

if i use <>'', the query seems is not my expected. how can i do that. Thanks!

Re: Retrieve not empty data

former_member189059 — Thu, 27 Sep 2007 10:58:54 GMT

try using NE instead of <>

Re: Retrieve not empty data

Former Member — Thu, 27 Sep 2007 10:58:57 GMT

use INITIAL or NULL instead of ''.

Also use NE instead of <>.

Please reward if useful.

Re: Retrieve not empty data

Former Member — Thu, 27 Sep 2007 10:59:27 GMT

Hi ,

You can use

Select ... from bseg where

augdt ne space.

Regards

Arun

Re: Retrieve not empty data

Former Member — Thu, 27 Sep 2007 11:00:46 GMT

This being a date fields Use AUGDT NE '00000000'. This will do

Message was edited by:

Mohammed Jaleel

Message was edited by:

Mohammed Jaleel

Re: Retrieve not empty data

Former Member — Thu, 27 Sep 2007 11:01:33 GMT

Hi,

Try to use this :

Select ... from bseg.

if audgt is not initial.

do the processingt

endif.

Regards,

Hemant

Re: Retrieve not empty data

varma_narayana — Thu, 27 Sep 2007 11:05:15 GMT

Hi ..

You can write like this...

SELECT <FIELDS> FROM BSEG

WHERE AUGDT IS NOT INITIAL.

SELECT <FIELDS> FROM BSEG

WHERE AUGDT ne SPACE.

Note: BSEG is a Cluster table . so the Where condition is allowed only on the Primary key.

REWARD IF HELPFUL.