CREATE VIEW TEST (TST_NAME, TST_FIRSTNAME, TST_FULLNAME )
AS
SELECT ADR_NAME, ADR_FIRSTNAME, ADR_NAME ||" "|| ADR_FIRSTNAME
FROM ADDRESS
WHERE ADR_TYPE=4;

remember that if either ADR_NAME or ADR_FIRSTNAME are null, the result of ||
is null


where ever you found this it's wrong
"I read in the documentation the string concatanation operator ||
is not supported in a SELECT statement."


--
Nick
-----We Solve your Computer Problems---
UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly



[Non-text portions of this message have been removed]