> -----Original Message-----
> or you can created a computed field called FIRSTLAST with
> that formula (I am too lazy to open the book, but you can
> look up how to define computed fields)

CREATE TABLE COMP (
FIRST_NAME VARCHAR(25) NOT NULL,
LAST_NAME VARCHAR(25) NOT NULL,
FULL_NAME COMPUTED BY (FIRST_NAME || ' ' || LAST_NAME)
);

Rgds

Si Carter
http://www.fbtalk.net/
http://www.tectsoft.net/