sgursahaney
Programmer
I would like to define a default value for a column using a computation of the value from another column. However, SQL Server complains when I specify another column in the default clause. For example, I would like to use the following formula as the default for column EXT:
SUBSTRING(CUST_PHONE,9,4)
where CUST_PHONE is another column in the table that has a phone number in it.
Does anybody know how to do this?
Thanks in advance.
SUBSTRING(CUST_PHONE,9,4)
where CUST_PHONE is another column in the table that has a phone number in it.
Does anybody know how to do this?
Thanks in advance.