In SQL Server, open the table in Design mode, select the field and set it to Identity and set the SEED to 1000.
-----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 03, 2007 7:58 AM To: CF-Talk Subject: SQL Server - starting integer at 1000 I've decided to change an orderID PK from varchar to int data type. I'll set it to have a yes identity so it'll increment, but how how do you set it to start at say, 1000. I don't want people's orders starting at 1. lol! Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4