Skip to Content
0
Former Member
Jan 09, 2008 at 02:32 PM

Select statement in ABAP

37 Views

Hi,

I have a table with couple of GUID fields. Primary key is the main GUID. I have another field by name temp_guid which can have the normal guid values or 00000000000000000000000000000000. I want to write a select statement as follows:

My table name : X

Field required : temp_guid

Select temp_guid FROM X where del_ind = gc_no AND temp_guid is NOT (??)

I dont want to select those rows where temp_guid has the value 00000000000000000000000000000000.

I tried with IS NOT NULL. It doesnt seem to be working. Any help would be appreciated.

thanks,

Ashwin