<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Some postcodes, like mine begin with a 0.</div><div>Validation rule could be that the first character of the postcode is a 3 for Victoria and that the value is 4 characters in length.<br>
<br><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt"><span style="background-color:rgba(255,255,255,0)">-- <br>Free and Open education for all<br><br>Peter Ruwoldt (aka Wara)</span></p><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt">
<span style="background-color:rgba(255,255,255,0)">Deputy Principal<br>Ernabella Anangu School<br>ERNABELLA SA 0872<br>PMB 63 via Alice Springs NT 0872<br><br>P. <a href="tel:08%208956%202977">08 8956 2977</a> </span></p>
<p class="MsoNormal" style="margin:0cm 0cm 0.0001pt"><span style="background-color:rgba(255,255,255,0)">M. <a href="tel:0419%20588%20365">0419 588 365</a><br>F. <a href="tel:08%208956%202930">08 8956 2930</a></span></p></div>
<div><br>On 28/05/2013, at 7:17 AM, Athena Spyratos <<a href="mailto:SP@boxhillhs.vic.edu.au">SP@boxhillhs.vic.edu.au</a>> wrote:<br><br></div><blockquote type="cite"><div>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaTempEditStyle"></style><style title="owaParaStyle"><!--P {
MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px
}
--></style>
<div style="FONT-SIZE:x-small;FONT-FAMILY:Tahoma;COLOR:#000000;DIRECTION:ltr">
<div></div>
<div dir="ltr"><font color="#000000" face="Tahoma">
<div style="FONT-SIZE:x-small;FONT-FAMILY:Tahoma;COLOR:#000000;DIRECTION:ltr">
<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>
<div dir="ltr"><font face="tahoma">Athena</font></div>
</div>
</font></div>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe</span><br>
<span>IT Applications Mailing List kindly supported by</span><br><span><a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br></span><br>
<span><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br></span><br><span><a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</span></div>
</blockquote></body></html>