MUSEUM-L Archives

Museum discussion list

MUSEUM-L@HOME.EASE.LSOFT.COM

Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Frank Thomson." <[log in to unmask]>
Reply To:
Museum discussion list <[log in to unmask]>
Date:
Mon, 31 Jul 1995 20:41:20 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (16 lines)
 <expect any similar scheme would work....but I would exhort you
 <not to use the 'x' thing, because it will create difficulties in a
 <computer database in which the numbers will need to be entirely numeric
 <for sorting purposes.

Regarding the use of x or other characters in Accession numbers.  It depends
on your set up, but if you have a choice the Accession number field should be
set as a character field, not numeric.  Characters include numbers and
letters.  The only time that numeric fields are necessary are when you need
to calculate-total value for insurance purposes, etc.  In a character field
numbers and letters can happily coexist and be sorted.

Frank Thomson
Curator
Asheville Art Museum

ATOM RSS1 RSS2