DROP TABLE IF EXISTS TBL1;
CREATE TABLE IF NOT EXISTS "TBL1"
(
   "isrc" VARCHAR(12),
PRIMARY KEY ("RecordID") 
LOCALE CODE 2070
);

CREATE INDEX IF NOT EXISTS "isrc" ON "tbl1" ("isrc");

INSERT INTO "tbl1" VALUES ('');
INSERT INTO "tbl1" VALUES ('');
INSERT INTO "tbl1" VALUES ('1');
INSERT INTO "tbl1" VALUES ('2');

SELECT ISRC FROM TBL1 WHERE ISRC>='' 

---

 Comments

---

We've also updated the Data Types and NULL Support section of the manual to include information on what results should be expected with the available operators when used with NULL values.

---

 Resolution

---

Fixed Problem on 9/20/2004 in version 4.11 build 1