It worked fine, Thanks a million

I will be looking at it shortly

There are a lot of rows, I am building this for a friend he supplied me with the sample data.

No I have not built any indexes.

This is being exported into a file, it is kinda a one time thing

but with many records, I have tried in Crystal, SQL if you have any other

ideas, I am...

The records are not one for one.

I have added the sequence number and it must be read in seq.

Record code 1 Seq 001 need to set the code = type...

CREATE TABLE tableName

(Tif varchar (255),

Type varchar(255),

Code varchar(10),

RC int,

SEQ int,

Descript varchar(30))

go

INSERT INTO tableName (Tif, Type, Code, RC, SEQ, Descript)

Values...

********************* DDL

Tifvarcharno255 yesnono.

Typevarcharno255 yesnono.

Codevarcharno10 ...