Retrieve not empty data

[Former Member]

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!

[former_member189059]

try using NE instead of <>

[Former Member]

use <b>INITIAL or NULL</b> instead of ''.

Also use <b>NE</b> instead of <>.

Please reward if useful.

[Former Member]

Hi ,

You can use

Select ... from bseg where

augdt ne space.

Regards

Arun

[Former Member]

This being a date fields Use <b>AUGDT NE '00000000'</b>. This will do

Message was edited by:

Mohammed Jaleel

Message was edited by:

Mohammed Jaleel

[Former Member]

Hi,

Try to use this :

Select ... from bseg.

if audgt is not initial.

do the processingt

endif.

Regards,

Hemant

[varma_narayana]

Hi ..

You can write like this...

SELECT <FIELDS> FROM BSEG

WHERE AUGDT IS NOT INITIAL.

or

SELECT <FIELDS> FROM BSEG

WHERE AUGDT ne SPACE.

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

REWARD IF HELPFUL.