[AccessD] Merge records

>If you think about it, JC, DELETE * is kind of redundant. 

Yep.  

Unfortunately we get used to using whatever SQL syntax works in the
environment that we work, day to day, which of course for me has been
Access.  Also unfortunately, each vendor adds extensions and "stuff" to the
SQL language which is non-standard.  This is a case apparently where the *
is a non-standard extension added to the ACCESS environment for reasons only
known to the vendor.  If you use the QBE grid to build a delete query in
Access, it inserts that * and you get used to seeing it, so it becomes "the
norm".  Once I scripted the table to a query in SQL Server the lack of the *
popped right out and I deleted it and voila.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, May 29, 2007 10:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Merge records

If you think about it, JC, DELETE * is kind of redundant. What else could
you mean?. You can't delete all the values in a column, for example. You can
DELETE WHERE but that is still all the columns.