Jack Corbett (5/18/2009)

---

First I suggest you read this article[/url] (disclaimer, I wrote it).

Then I suggest you read the first article in my signature line if you want code examples. ...

Is this what you mean?

CREATE TABLE [sysdba].[QG_ACCSERVCATEGORY](

[QG_ACCSERVCATEGORYID] [char](12) NOT NULL,

[ACCOUNTID] [char](12) NOT NULL,

[CREATEUSER] [char](12) NULL,

[CREATEDATE] [datetime] NULL,

[MODIFYUSER] [char](12) NULL,

[MODIFYDATE] [datetime] NULL,

[JOINDATE] [datetime] NULL,

[LASTCLEANEDDATE] [datetime] NULL,

[LASTCLEANEDUSER] [varchar](80) NULL,

[LEAVINGDATE] [datetime] NULL,

[PAYMENTSTATUS] [varchar](32)...