<div dir="ltr">On the one hand, it is possible to do arithmetic with postcodes (e.g. to find neighbouring areas) so number is good.<div style>On the other hand, some postcodes have leading zeroes, which would be thrown away if stored as number.</div>
<div style><br></div><div style>The best bet, I'd say, is to store them as number and format them with zero padding to 4 digits for output purposes.</div><div class="gmail_extra"><br><br><div class="gmail_quote">On 28 May 2013 07:47, Athena Spyratos <span dir="ltr"><<a href="mailto:SP@boxhillhs.vic.edu.au" target="_blank">SP@boxhillhs.vic.edu.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div style="direction:ltr;font-size:x-small;font-family:Tahoma">
<div></div>
<div dir="ltr"><font color="#000000" face="Tahoma">
<div style="direction:ltr;font-size:x-small;font-family:Tahoma">
<div></div>
<div dir="ltr"><font color="#000000" face="Tahoma">Fellow IT teachers.</font></div>
<div dir="ltr"><font face="tahoma">Do we declare the data type for Postcode as number or text? In database, if we apply a validation rule for a Victorian postcode as being between 3000 and 3999, then we declare it as a number. However going over one of the
past exam multiple choice questions, the answer they wanted for the data type for Postcode was text. Which answer are the examiners looking for?</font></div><span class="HOEnZb"><font color="#888888">
<div dir="ltr"><font face="tahoma">Athena</font></div>
</font></span></div>
</font></div>
</div>
</div>
<br></blockquote></div><div dir="ltr">--<div>Mark Kelly</div><div>mark AT vceit DOT com</div><div><a href="http://vceit.com" target="_blank">http://vceit.com</a></div><div><br></div></div>
</div></div>