<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 {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm 0pt
}
LI.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm 0pt
}
DIV.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm 0pt
}
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 {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; MARGIN: 0cm 0cm 0pt
}
SPAN.EmailStyle18 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d
}
.MsoChpDefault {
FONT-SIZE: 10pt
}
</style><style id="owaTempEditStyle"></style><style title="owaParaStyle"><!--P {
MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px
}
--></style>
<meta name="GENERATOR" content="MSHTML 10.00.9200.16576">
</head>
<body lang="EN-AU" link="blue" vlink="purple" ocsi="x">
<div style="FONT-SIZE: x-small; FONT-FAMILY: Tahoma; COLOR: #000000; DIRECTION: ltr">
<div>And that should be the end of the argument.</div>
<div> </div>
<div>Postcodes are entered as text not numbers.</div>
<div> </div>
<div>Mark Scott</div>
<div>Luther College</div>
<div> </div>
<div dir="ltr"><font color="#000000" size="2" face="Tahoma"></font> </div>
<div id="divRpF92867" style="DIRECTION: ltr">
<P>
<TABLE style="WIDTH: 400px" cellSpacing=0 cellPadding=0 background=""
border=0><TBODY>
<TR>
<TD><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #184689; PADDING-TOP: 5px; FONT-FAMILY: arial">Mark Scott </SPAN>
<SPAN style="FONT-WEIGHT: bold; FONT-SIZE: 10px; COLOR: #184689; PADDING-TOP: 5px; FONT-FAMILY: arial"><BR></SPAN>
<SPAN style="MARGIN-TOP: 0px; FONT-SIZE: 12px; COLOR: #184689; FONT-FAMILY: arial">Daily Administrator<BR></SPAN>
<SPAN style="MARGIN-TOP: 0px; FONT-SIZE: 7px; COLOR: #FFFFFF; FONT-FAMILY: arial">Luther<BR></SPAN>
<DIV
style="FONT-SIZE: 12px; COLOR: #808285; PADDING-TOP: 15px; FONT-FAMILY: arial">Plymouth
Road<BR>Croydon Hills Victoria 3136<BR>
<BR></DIV>
<SPAN style="MARGIN-TOP: 0px; FONT-SIZE: 7px; COLOR: #FFFFFF; FONT-FAMILY: arial">Luther<BR></SPAN>
<DIV
style="FONT-SIZE: 12px; COLOR: #808285; PADDING-TOP: 5px; FONT-FAMILY: arial"><SPAN>Telephone
(03) 9724 2000<BR>Direct Line</SPAN> (03) 9724 2023
<DIV style="COLOR: #808285; PADDING-TOP: 5px">
<A style="COLOR: #808285; TEXT-DECORATION: none" href="http://www.luther.vic.edu.au/"><FONT face=Arial
size=2>www.luther.vic.edu.au</FONT></A>
<DIV style="FONT-SIZE: 9px; COLOR: #808285; PADDING-TOP: 5px"></DIV>
</DIV></DIV></TD>
<TD><A href="http://www.luther.vic.edu.au/"><FONT face=Arial><IMG
id=luther title="Luther College" style="WIDTH: 143px; HEIGHT: 143px"
height=143 alt="Luther College" hspace=0
src="cid:luther_college_email8e06bb"
width=143 align=textTop border=0 name=luther
college></FONT></A></TD></TR></TBODY></TABLE></P>
<P></P>
<DIV style="CLEAR: both; MARGIN-TOP: 10px; FLOAT: left; WIDTH: 100%"><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 9px; COLOR: #ca003a; LINE-HEIGHT: 110%; FONT-FAMILY: arial">Please
consider the environment before printing this email.<BR></SPAN>
<P
style="MARGIN-TOP: 5px; FONT-SIZE: 9px; COLOR: #808285; LINE-HEIGHT: 110%; FONT-FAMILY: arial">This
email and any attachments may contain privileged and confidential information.
<BR>If you are not the intended recipient you may not distribute or reproduce
this email <BR>or attachments. If you have received this message in error please
notify us by return mail.</P></DIV><BR style="CLEAR: both">
<DIV></DIV><br><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 Wayne Eglinton [wayne.eglinton@ntschools.net]<br>
<b>Sent:</b> Wednesday, May 29, 2013 9:15 PM<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 style="FONT-SIZE: x-small; FONT-FAMILY: Tahoma; COLOR: #000000; DIRECTION: ltr">
<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 id="divRpF349079" style="DIRECTION: ltr">
<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-SIZE: 11pt; FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">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-SIZE: 11pt; FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d"></span> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">Stuart Walkerden</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d">Huntingtower</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d"></span> </p>
<div>
<div style="BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0cm; PADDING-TOP: 3pt; PADDING-LEFT: 0cm; BORDER-LEFT: medium none; PADDING-RIGHT: 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</span></b><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> 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-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black">Fellow IT teachers.</span></p>
</div>
<div>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black">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-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: black">Athena</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>