In a table, I configed a field as 'Autonumber', but I do not want it to be 1,2,3,4,5. but I want it to look like this '0001', '0002'. How can I achieve this? thanx

There is no way to set an identity column to store this value. I suggest you other approach to reach this.    Create another table no_gen with column PNO (INT), CREATETIME (DATETIME). Set the column PNO as an identity column.    If your original table is ORDERS with column PNO (INT), xxxx (datatype), ....., Set the column PNO as datatype of char(4)    Before you insert a new ORDERS record, insert a new record into table no_gen with:    SET NOCOUNT ON;INSERT INTO no_gen (CREATETIME) VALUES (getdate());SELECT @@IDENTITY to get the new PNO value, and then use dephi procedure (sPNO := RightStr('0000' INTTOSTR(iPNO),4)) to fulfill the value with '0' like '0001', '0002' and then insert the ORDERS table with: 'INSERT INTO ORDERS (PNO, XXX1, ...) VALUES ( ' sPNO ', ....... ) This method may not be best, but it works!!

In the table / query linking to that autonumber table : 1. double click that table/query 2. in the field editor, right click and select add all fields 3. Click the autonumber field 4. In the property edit, change to event page 5. setup the onGetText Event : Text := Format('%4.4d',[Sender.AsInteger]); 6. setup the onSetText Event : Sender.AsInteger := StrToInt(Text); That's it.

THanks Justmade u are always my lifesaver