(using FB 1.5 rc4) is this kind of statement possible:

SELECT 'abc' AS c1 FROM RDB$DATABASE
UNION ALL
SELECT c1 FROM some_table

where some_table.c1 is a varchar / char column? I
get SQLCODE -104 errors but can't find any
method of casting the 'abc' which will work with the
union statement.


Ian Barwick
barwick@...