Question about format of a query

[greaseman]

I've got a database of documents, some of which have pages where there is nothing but the character "*" on an occasional page.

I want to write a query that will process these documents, but ignore the pages that contain nothing but that pesky character, "*".

If I wrote a query like

SELECT Min([PageN]) AS OldPageN FROM [ED_Pg_Hist] WHERE NOT [PgDate] LIKE '(*)'

Would it do what I want? Or, should I write my query like this:

SELECT Min([PageN]) AS OldPageN FROM [ED_Pg_Hist] WHERE NOT [PgDate] LIKE '(%)'

If anyone has a comment, suggestion or idea, would you be sl kind as to pass it my way? Thanks in advance!!

 

[neileg]

Trouble is that * is the wildcard character in Access so that may mean that it will match everything! You may have to use the ASCII code for the asterisk.