<div>
computed column is the answer:<br />
<a href="http://msdn.microsoft.com/en-us/library/ms187768.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms187768.aspx</a>
</div>


computed column is the answer:
http://msdn.microsoft.com/en-us/library/ms187768.aspx [http://msdn.microsoft.com/en-us/library/ms187768.aspx]

<div>
Could you show me using the information I gave you?
</div>


Could you show me using the information I gave you?

<div>
hmmm. actually, you want to change the value to 3 only and once the value of age changes to 18 or higher?<br />
then, you need a trigger...<br />
does your table have a primary key?
</div>


hmmm. actually, you want to change the value to 3 only and once the value of age changes to 18 or higher?
then, you need a trigger...
does your table have a primary key?

<div>
<div class="content wysiwyg-content">
I have two columns in my SQL Express Table. &nbsp;If Age column = 18 or above, then the Code column should have the number in it changed to 3.<br />
<br />
How can I automatically make the Code column do this?
</div>
</div>


I have two columns in my SQL Express Table.  If Age column = 18 or above, then the Code column should have the number in it changed to 3.

How can I automatically make the Code column do this?

calculation for opposite column

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.