>> The majority of the problems I've run into are with fields using SQL keywords -- they cause a SQL SELECT statement to fail with syntax errors. For example, one system I worked with had a field called DESC (short for "description"). SELECT DESC FROM TABLE gives an error because DESC is a SQL keyword (short for "descending"). <<

Hi Doug,

I worked on an application several years ago with a friend of ours. The app handled purchase orders and he had named one of the tables order.dbf. Whoops <g>.

Mike