Chuck:
> Fabio wrote:
> >
> > I want a field in my table to autoincrement like 'CHD0001', 'CHD0002',
> > 'CHD0003'

> Why does the CHD prefix need to be there? Will it ever change?
>
> If not it's unnecessary. It can be generated when you query the column
> or with a view.

If CHD is there for presentational purposes only, I would prefer putting
it into the presentation (or logic) layer instead of using the database
to do that.

--
Erick