-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
CREATE TABLE textus (id INTEGER PRIMARY KEY, txtf TEXT);
INSERT INTO textus VALUES(1, 'xxx');
INSERT INTO textus VALUES(2, '');
INSERT INTO textus VALUES(3, NULL);
SELECT id,txtf,CONCAT('', txtf),COALESCE(txtf,'') FROM textus;
DROP TABLE textus;
