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.