Posted by SQL Learner on 03/01/07 23:22

Hi,

I have a table with 8 millions records. Some of the fields needed to
be parse and modified. Example, "ABC DEF" will be parsed into two
fields "ABC" and "DEF". And If there is "123" in the field, if will
be replaced by "456". For example, "XYZ 123 AAA" will be "XYZ 456
AAA". Also, update query and append query will be used in the
project.

Give the above information, what will be a faster database to do this
- MS-Access 2003 or SQL Server 2000?

[Back to original message]