[Year 12 IT Apps] Data type for postcode

[Peter Ruwoldt]

Some postcodes, like mine begin with a 0.
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.

-- 
Free and Open education for all

Peter Ruwoldt (aka Wara)

Deputy Principal
Ernabella  Anangu School
ERNABELLA  SA  0872
PMB 63 via Alice Springs NT 0872

P. 08 8956 2977

M. 0419 588 365
F. 08 8956 2930

On 28/05/2013, at 7:17 AM, Athena Spyratos <SP at boxhillhs.vic.edu.au> wrote:

    Fellow IT teachers.
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?
Athena

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority <br>
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
Association Inc <br>
http://www.swinburne.edu.au/ict/schools - Swinburne University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130603/85b1046b/attachment.html