Thanks,
That fixed the problem I was having. Now, I just have to figure out how to read something like this.

CREATE TABLE "a2k"."DA2404_DISCREPANCY"
(
    "MR_CONTROL_NO"         varchar(30) NOT NULL,
    "DISCREP_NO"            integer NOT NULL,
    "TM_ITEM"               varchar(4) NULL,
    "STATUS"                varchar(1) NULL,
    "DEFICIENCY"            varchar(30) NULL,
    "CORRECTION"            varchar(30) NULL,
    "INITIALS"              varchar(3) NULL,
    PRIMARY KEY ("MR_CONTROL_NO", "DISCREP_NO") WITH HASH SIZE 10
)
go
[download]

I want to change VARCHAR to VARCHAR2. I know that the ^ is to anchor at the beginning of a line. What does the $ do, exactly?
Thanks,
Bobby