1-- 2-- VARCHAR 3-- 4 5CREATE TABLE VARCHAR_TBL(f1 varchar(1)); 6 7INSERT INTO VARCHAR_TBL (f1) VALUES ('a'); 8 9INSERT INTO VARCHAR_TBL (f1) VALUES ('A'); 10 11-- any of the following three input formats are acceptable 12INSERT INTO VARCHAR_TBL (f1) VALUES ('1'); 13 14INSERT INTO VARCHAR_TBL (f1) VALUES (2); 15 16INSERT INTO VARCHAR_TBL (f1) VALUES ('3'); 17 18-- zero-length char 19INSERT INTO VARCHAR_TBL (f1) VALUES (''); 20 21-- try varchar's of greater than 1 length 22INSERT INTO VARCHAR_TBL (f1) VALUES ('cd'); 23INSERT INTO VARCHAR_TBL (f1) VALUES ('c '); 24 25 26SELECT * FROM VARCHAR_TBL; 27 28SELECT c.* 29 FROM VARCHAR_TBL c 30 WHERE c.f1 <> 'a'; 31 32SELECT c.* 33 FROM VARCHAR_TBL c 34 WHERE c.f1 = 'a'; 35 36SELECT c.* 37 FROM VARCHAR_TBL c 38 WHERE c.f1 < 'a'; 39 40SELECT c.* 41 FROM VARCHAR_TBL c 42 WHERE c.f1 <= 'a'; 43 44SELECT c.* 45 FROM VARCHAR_TBL c 46 WHERE c.f1 > 'a'; 47 48SELECT c.* 49 FROM VARCHAR_TBL c 50 WHERE c.f1 >= 'a'; 51 52DROP TABLE VARCHAR_TBL; 53 54-- 55-- Now test longer arrays of char 56-- 57 58CREATE TABLE VARCHAR_TBL(f1 varchar(4)); 59 60INSERT INTO VARCHAR_TBL (f1) VALUES ('a'); 61INSERT INTO VARCHAR_TBL (f1) VALUES ('ab'); 62INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd'); 63INSERT INTO VARCHAR_TBL (f1) VALUES ('abcde'); 64INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd '); 65 66SELECT * FROM VARCHAR_TBL; 67