COLUMN FORMULA

Here is an example:

CREATE TABLE tbl (
idCol INT NOT NULL IDENTITY,
vcol1 VARCHAR(20) NOT NULL,
vcol2 VARCHAR(20) NOT NULL,
compcol AS LEFT(vcol1, 2) + CAST(idcol AS VARCHAR) + RIGHT(vcol2, 1));

If these are nullable columns, then you have to use ISNULL/COALESCE to
change the values to avoid string concatenation on NULLs.

--
Anith
 >> Stay informed about: COLUMN FORMULA 

Thanks/Sorry
Which group did you forward it to?

"soc" <zxc0.DeleteThis@yahoo.com> wrote in message
news:unM21PyGEHA.3360@TK2MSFTNGP12.phx.gbl...
 > Is it possible to generate a password column by putting an expression into
 > the formula field when defining the column, to combine other fields? e.g.
 > (left([varcharcol1],2) &[integeridentitycol] & right([varcharcol2],1))
 >
 > Thanks Sean.
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: COLUMN FORMULA 

Many thanks Anith!
"Anith Sen" <anith.RemoveThis@bizdatasolutions.com> wrote in message
news:eH0j089GEHA.3060@TK2MSFTNGP10.phx.gbl...
 > Here is an example:
 >
 > CREATE TABLE tbl (
 > idCol INT NOT NULL IDENTITY,
 > vcol1 VARCHAR(20) NOT NULL,
 > vcol2 VARCHAR(20) NOT NULL,
 > compcol AS LEFT(vcol1, 2) + CAST(idcol AS VARCHAR) + RIGHT(vcol2,
1));
 >
 > If these are nullable columns, then you have to use ISNULL/COALESCE to
 > change the values to avoid string concatenation on NULLs.
 >
 > --
 > Anith
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: COLUMN FORMULA