I got an address table. Now I'd like to create a VIEW with a field
with the contcatenated ADR_NAME and ADR_FIRSTNAME => ADR_FULLNAME. As
far a I read in the documentation the string concatanation operator ¦¦
is not supported in a SELECT statement. So I tried something like
TST_FULLNAME COMPUTED BY (ADR_NAME¦¦" "¦¦ADR_FIRSTNAME) in the CREATE
VIEW statement like in a CREATE TABLE statement. But unfortunatly this
doesn't work either.

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

Can somebody tell me how to create my VIEW with the concatenated
ADR_FULLNAME? Thanks in advance.

Markus from Switzerland