How to map number to marital status
<p>I have a marital status field in a database with numbers each representing a marital status in a different table. The first table has numbers 1, 3, 4:</p>

<pre>
1 = single 
3 = married
4 = divorced 
</pre>

<p>The second has the values:</p>

<pre>
single
married
divorced 
</pre>

<p>I need an if statement as follows: if the table field returns the value 1 I want to write the message 'single', if 3 'married' and if 4 'divorced' (using Response.Write).</p>
