<html><head></head><body bgcolor="#FFFFFF"><div>Have you looked at northern territory postcodes?</div><div><br></div><div>E.g. 0800 for Darwin</div><div><br></div><div>Then look at overseas postcodes... E.g. Canada two digits, two letters two digits</div><div>E.g. UK two letters, two digits, two letters</div><div><br></div><div>Unless of course you want your software only work in Victoria?</div><div>Also when doing Victorian remember that Vic postcodes also include 8000 to 8999 and NSW 9000 to 9999 .. Students are interested to discover why</div><div><br></div><div>Andrew<br><br><div><br></div><div>Andrew Shortell</div><div>Educator</div><div>CRC Melton</div><div><br></div><div><a href="mailto:shortell@get2me.net">shortell@get2me.net</a> (lists)</div><div><a href="mailto:andrew@get2me.net">andrew@get2me.net</a> (personal)</div><div>@acsbear (twitter)</div><div>VITTA CoM member</div><div>Skype: acshortell</div><div><br></div><div>Sent from my iPad</div></div><div><br>On 28/05/2013, at 7:47 AM, Athena Spyratos <<a href="mailto:SP@boxhillhs.vic.edu.au">SP@boxhillhs.vic.edu.au</a>> wrote:<br><br></div><div></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" size="2" face="Tahoma">
<div style="FONT-SIZE: x-small; FONT-FAMILY: Tahoma; COLOR: #000000; DIRECTION: ltr">
<div></div>
<div dir="ltr"><font color="#000000" size="2" 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>