Hi,
I have a table with a Unique ID named U_ID that come from a sequence like
that :
create table the_table( U_ID integer default NEXTVAL('THE_SEQUENCE'), ...
and I would like to have a field of type varchar that would be something
like
create table the_table( U_ID integer default NEXTVAL('THE_SEQUENCE'), name varchar(50) default 'NT_'+itoa(U_ID)
);
so the field 'name' would be the string concatenation of "NT_" and the
string value of the field U_ID.
Is there a way to do this?
Thanks for your precious help! ;)
\fb
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com