Hi All,

I have a database which has terms (english words) as key values and I
need to take up all keys from the database and segregate them into
multiple databases according to the first letter of the key values.

For example if the database has the following keys,
1. abroad
2. async
3. method
4. mind
5. zebra

What I need to do is create three databases with abroad, async in one
method, mind in another and zebra in another. I could do it using
cursor and taking up one key value at a time, comparing the first
alphabets and storing the database records to the concerned database.

But I have thousands of records and it becomes extremely intensive to
do it that way. Could anyone suggest a cleaner and efficient solution.

Thanks,
Animesh
-MirrorZen Software