Thanks Buddy.
On Thu, 19 Apr 2001 15:46:21 -0400 "Walker,
Buddy" <[EMAIL PROTECTED]> wrote:
> 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]
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
