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 '' AS seven, * FROM VARCHAR_TBL; 27 28SELECT '' AS six, c.* 29 FROM VARCHAR_TBL c 30 WHERE c.f1 <> 'a'; 31 32SELECT '' AS one, c.* 33 FROM VARCHAR_TBL c 34 WHERE c.f1 = 'a'; 35 36SELECT '' AS five, c.* 37 FROM VARCHAR_TBL c 38 WHERE c.f1 < 'a'; 39 40SELECT '' AS six, c.* 41 FROM VARCHAR_TBL c 42 WHERE c.f1 <= 'a'; 43 44SELECT '' AS one, c.* 45 FROM VARCHAR_TBL c 46 WHERE c.f1 > 'a'; 47 48SELECT '' AS two, 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 '' AS four, * FROM VARCHAR_TBL; 67