<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Hi<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Now do we have a debate about the worth of Wikipedia as a source of information?<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Maybe another day.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:Wingdings;color:#1F497D'>J</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Mark<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><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_email16c7ec"
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><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='mso-fareast-language:EN-AU'>From:</span></b><span lang=EN-US style='mso-fareast-language:EN-AU'> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Watson, Donald R<br><b>Sent:</b> Thursday, 30 May 2013 9:45 AM<br><b>To:</b> itapps@edulists.com.au<br><b>Subject:</b> [Year 12 IT Apps] database convention - postcodes as a text field in databases<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hello All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The link below pretty much says it all. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>T<b>he convention</b> is that postcodes should defined and be input as text.<o:p></o:p></p><p class=MsoNormal>Of course there could be circumstances in which a specialised database might need to use some ‘regional intelligence’ based on a postcode. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>A mail drop to all postcodes between 3850 and 3860 covers my area of Gippsland for example. It saves time on listing 100’s of towns in a complicated case or nested if statement.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom">http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Don<o:p></o:p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.<o:p></o:p></p></div></body></html>