How can I create/define a field so it'll be of the automatically increasing type with a SQL sentence? If it must be done during table creation, that's cool too.

Thanks

Create table a
(
name varchar2(100)
);

Alter table a
modify name varchar2(200);

Are you asking how to create a column that will increase in value, or increase in size? If you are looking to create something analagous to Oracle's rowid, the syntax is different for each database engine, so you'll have to tell us which engine you are using for us to give you one answer.

-PatP

It's on ACCESS.

That's helpful, but are you looking for an MS-Access AUTONUMBER column, or a TEXT column that will increase in length each time you do something?

-PatP

AUTONUMBER please..

It's not on ACCESS really, it's on a SQL server. But I figured it's about he same. No?

create table tableA
(
id INTEGER IDENTITY(1, 1)
...
)