<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
SPAN.EmailStyle18 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d
}
.MsoChpDefault {
FONT-SIZE: 10pt
}
DIV.WordSection1 {
}
</style>
<meta name="GENERATOR" content="MSHTML 9.00.8112.16484">
<style id="owaTempEditStyle"></style><style title="owaParaStyle"><!--P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
--></style>
</head>
<body lang="EN-AU" vlink="purple" link="blue" ocsi="x">
<div style="FONT-FAMILY: Tahoma; DIRECTION: ltr; COLOR: #000000; FONT-SIZE: x-small">
<div>FYI</div>
<div> </div>
<div>living in the NT ... I'm fully aware of the 0 lead character in postcodes. Too bad web-developers don't consider using text for post/zipcodes fields ... often we can't subscribe etc... It can seriously be a pain - and we just go to another website... bad
for their business!!!</div>
<div>
<div class="BodyFragment"><font size="2">
<div class="PlainText"> </div>
<div class="PlainText"><font face="tahoma">Food for thought for you & your students.</font></div>
<div class="PlainText"><font face="tahoma"></font> </div>
<div class="PlainText">Regards,<br>
<br>
Wayne Eglinton<br>
<br>
OLSH College<br>
P.O. Box 2508</div>
<div class="PlainText">Traeger Ave.<br>
Alice Springs NT 0871<br>
<br>
P 08 8950 8555</div>
<div class="PlainText">M 0406 357 972</div>
</font></div>
</div>
<div dir="ltr"><font color="#000000" size="2" face="Tahoma"></font> </div>
<div style="DIRECTION: ltr" id="divRpF349079">
<hr tabindex="-1">
<font color="#000000" size="2" face="Tahoma"><b>From:</b> itapps-bounces@edulists.com.au [itapps-bounces@edulists.com.au] On Behalf Of Stuart Walkerden (STUW) [stuw@huntingtower.vic.edu.au]<br>
<b>Sent:</b> 28 May 2013 13:20<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] Data type for postcode<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I reckon if it looks like a number, treat it as a number and use a number field type. Whether you perform calculations on it or not is irrelevant. I have
always told my students to use postcode as a number and phone as text to allow for leading 0. I wasn’t aware of NT postcodes. I may have to change my line.</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"></span> </p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Stuart Walkerden</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Huntingtower</span></p>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"></span> </p>
<div>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<p class="MsoNormal"><b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">From:</span></b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang="EN-US"> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au]
<b>On Behalf Of </b>Athena Spyratos<br>
<b>Sent:</b> Tuesday, 28 May 2013 7:47 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> [Year 12 IT Apps] Data type for postcode</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt">Fellow IT teachers.</span></p>
</div>
<div>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt">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?</span></p>
</div>
<div>
<p class="MsoNormal"><span style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black; FONT-SIZE: 10pt">Athena</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>