>I need to create 3 new tables from
> a table
>
> Field name:
>
> table 1; Names (first letter) from A to F
> table 2; Names (first letter) from G to P
> table 3; Names (first letter) from Q to Z

select * from myTable where Names between 'A' and 'F' into table New1
select * from myTable where Names between 'G' and 'P' into table New2
select * from myTable where Names between 'Q' and 'Z' into table New3

Cetin