Bob
Make your column AUTONUM with a format of [HOT]9999
Buddy
-----Original Message-----
From: Bob Powell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 3:38 PM
To: [EMAIL PROTECTED]
Subject: Cancatenating
Does anyone know how to auto-generate a unique column that
allows me to always have a specific text string in front of
it?
I want to be able to generate unique id's that always start
with the letters "HOT". Therefore, id numbers would be
HOT234, HOT235, etc. I would like the id number column to
be of type text. If so, is there a way to do this in the
table definition screen using an expression so that the
table does it automatically?
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
