[AccessD] precursor zero

String & Right("0000" & CStr(ID), 4)

Will take care of it.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro Janssen
Sent: Friday, November 12, 2004 1:38 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] precursor zero


Hello Group,

 i can make an ID by placing a string and a number together with an update query.
What i get then is 

string1
string2
string11
string100

What i would like is precursor zero's so that all number are the same length:

string0001
string0002
string0011
string0100

How can i do this?

Pedro Janssen
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com